Excel lookup based on two columns...
Posted on 2013-11-22
I am trying to compare columns A1 and B1 to Columns P and Q respectively and if they match I want column R.
Here is what I have which doensn't work:
Problem is that I don't know what the row # is in R since it could match on 121 or 2 or...
So trying to use the row function didn't work out. I need help with the value resulting from true ($R:R(ROW))
If the value evaluates to true I want the corresponding row value for column R.
Thanks in advance!