I am having the exact problem. I have sorted, formatted, double checked
everything--can see the result is there, but it will not pull in. This is
very frustrating. In the meantime, I have to put the data in manually.

"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