VLOOKUP

C

C3

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!
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Named Cell 1
EXCEL - IF(IFERROR(VLOOKUP question 0
combo box 1
Macro to send email 5 days before a date mentioned in Cell 1
find function 4
transformed vloopup 2
vlookup function 1
Formula using one out of five cells from the other row 0

Top