VLOOKUP
Help!
How to retrieve data from a sheet with VLOOKUP function if I have:
Sheet1:
A B C D E
1 22 33 44 55 XYZ
In cell E1 I have formula: =IF(C1<=B1;"XYZ";"OK")
Sheet2:
A B C
1
In cell A1 I have formula: =VLOOKUP("XYZ";Sheet1!1:1;2;FALSE) to fill me in
cell A1 data of cell B1 for a row wich contains "XYZ"
All that don't work, help!
|