Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C3 C3 is offline
external usenet poster
 
Posts: 13
Default 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!