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!

VLOOKUP
 

Hi
not sure but try the following in A1 on sheet2
=INDEX('Sheet1'!B!:B100,INDEX("XYZ",'sheet1'!E1:E1 00,0))

--
Regards
Frank Kabel
Frankfurt, Germany


C3 wrote:
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!