Debra Dalgleish has lots of notes on troubleshooting =vlookup():
http://contextures.com/xlFunctions02.html#Trouble

SJayTee wrote:

I have the following formula:

=VLOOKUP(B27,BOM!$A$10:$M$99,13,FALSE)

which is returning an error #N/A.

I know the information is there because I can see it.

I have check and re-checked all of the arguments and can't see what's wrong.

Can anybody help?
--
SJT

--

Dave Peterson