VLOOKUP not working

[moldo89]

Hi everyone,
I have a problem with my vlookup function. I will share an example:
A: B: C: D: E: =IFERROR(INDEX($C$1:$C$10,SMALL(IF(ISNUMBER($C$1:$C$10),ROW($C$1:$C$10)),ROWS(E$1:E1))-ROW($C$1)+1),"")
10 Yes Yes VLOOKUP($E1:$E10, 250
70 No 250 $A$1:$C$10,1,FALSE) 400
30 No No 120
80 Yes 400
50 Yes Yes
11 No 120

Any ideea why not working?
Thanks!

[Norie]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Tony Valko]

Instead of using VLOOKUP use:

=INDEX(A$1:A$10,MATCH(E1,C$1:C$10,0))

[moldo89]

Here it is!
Thank you!

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.