Vlookup Issue

**mowine** · 01-09-2011, 06:40 PM

I am having an issue with the data in a VLOOKUP formula. I have done a fair amount of research online and have spent several hours trying to figure out the problem with the data integrity between the key columns. I haven't been able to figure it out, so I thought I would ask this esteemed group. The worksheet is attached.

NBA.xlsx

Observation:
If I remove 2 rows of key data above the match, the VLOOKUP does return the correct value.

A - Trying to cleanse the data from B for the VLOOKUP fucntion.
B, C, D - Extrated Data from column I
F, G - Test VLOOKUP function
I - Original Source Data

**stanleydgromjr** · 01-09-2011, 06:52 PM

mowine,

In worksheet Doesn't Find Match, in cell H1, enter the following formula, and copy down:

=IF(ISNA(INDEX(C:C,MATCH(F1,A:A,0),1)),"",INDEX(C:C,MATCH(F1,A:A,0),1))

**teylyn** · 01-09-2011, 07:02 PM

Hello,

If you use Vlookup without the fourth parameter, it expects the list to be sorted, which it is not.

Use False as the fourth parameter

=VLOOKUP(F1,$A$1:$D$30,3,FALSE)

and all will be good.

@ Stan, in Excel 2007 and older, you could also use IFERROR

=IFERROR(INDEX(C:C,MATCH(F1,A:A,0),1),"")