vlookup() returning N/A question

**cwyte** · 03-19-2009, 03:59 PM

Hello I have a very basic vlookup function. One table, two columns, 5records. Vlookup inop

I am attaching a screen shot jpeg which displays the problem:

Any idaes are greatly appreciated.

**ConneXionLost** · 03-19-2009, 04:04 PM

The N/A just means that what you are looking for is not in the list.

If you don't want to see that, then try:

Please Login or Register  to view this content.

**cwyte** · 03-19-2009, 04:11 PM

Originally Posted by ConneXionLost

The N/A just means that what you are looking for is not in the list.

If you don't want to see that, then try:

Please Login or Register  to view this content.

I know what it means, take a look at the screenshot my value is definitely on the list?

**daddylonglegs** · 03-19-2009, 04:13 PM

If you want to lookup E2 in column C and return the value from column B then you can't do that with VLOOKUP, try INDEX/MATCH, i.e.

=INDEX(B8:B12,MATCH(E2,C8:C12,0))

**ConneXionLost** · 03-19-2009, 04:22 PM

Sorry, I misunderstood your question.

VLOOKUP looks for a match in the "leftmost" column of a table.

You might try reversing your columns.

(Or try daddylonglegs' solution).