|
Posted to microsoft.public.excel.misc
|
|
|
Vlookup incorrect #n/a error
"Chip Pearson" wrote:
The first thing to do is double check both B27 and the cell you think
should match to ensure that there are no extra spaces or non-visible
control characters. You can use my CellView add-in to see exactly what
is in a cell, including characters that aren't displayed. See
http://www.cpearson.com/excel/CellView.aspx for details and free
download.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Tue, 7 Apr 2009 04:01:01 -0700, 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?
|