VLOOKUP missing some part numbers

[sburkhar]

Why would my VLOOKUP only be returning values that begin with a number? Some of our part numbers begin with a letter and it's not returning any of those.

Terminal;General;Box;SN 976750
Terminal;Eyelet 7009513902
PB547-02880
PBF111-1.6MG8

here is my VLOOKUP formula:
=IF(ISERROR(VLOOKUP(F29,'C:\Documents and Settings\sburkhar\Desktop\[VLOOKUP.xls]PRICE'!$B$1:$C$65536,2,FALSE)),"",VLOOKUP(F29,'C:\Documents and Settings\sburkhar\Desktop\[VLOOKUP.xls]PRICE'!$B$1:$C$65536,2,FALSE))

 

[rs2k]

Have you checked for leading/trailing spaces?

How are you entering data into F29?

 

[sburkhar]

I removed leading and trailing spaces via ASAP utilities.

Data is usually entered by copy and paste. in this case I copied and pasted directly from the VLOOKUP to make sure it was working and it's only capturing numbers and nothing that begins with a letter.

I think I may have stated my issue backwards, I am entering the Part Number expecting to get a description of the part returned. the VLOOKUP is only returning descriptions for Part Numbers that begin with a number.

 

[rs2k]

Try breaking down the formula, remove the error capture and just try a simple vlookup;

=VLOOKUP(F29,'C:\Documents and Settings\sburkhar\Desktop\[VLOOKUP.xls]PRICE'!$B$1:$C$65536,2,FALSE)

Does this return the correct result?

 

[sburkhar]

I did that and I think we found the problem.....thanks! the confusing part is that it's been working fine for days and I came in this morning and it wasn't working. I hate when that happens.