I have created the following function to cross reference a cell holing a number with a range of cells holding numbers on another sheet, using false for identical match. My problem is that I need to return the value of an adjacent cell to that of the true matched result.
=IF(ISNA(VLOOKUP(A13,'FAX CONTROL INFO'!$L$2:$L$1061,1,FALSE)),"'FAX CONTROL INFO'!N13","Yes")
For example:
sheet1
A
==|===|
1 | 10
2 | 11
3 | 12
sheet2
A B
==|===|====|
1 | 10 john
2 | 11 fred
3 | 12 bill
My look up would check to see if sheet1, A1 exists within range sheet2, A1:A3 and return B1 as it is a true match with sheet2, A1 - hope this makes sense. As a note, I will have multiple matches but only need to return one result as all matches would be the same.
If anyone has done this sort of thing before and can help me out or point me to another resources it would be much appreciated – thanks for your time.
Bookmarks