Vlookup incorrect #n/a error

  • Thread starter Thread starter SJayTee
  • Start date Start date
S

SJayTee

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?
 
We can't help without seeing your data and layout, at least a significant
excerpt.
Regards,
Stefi

„SJayTee†ezt írta:
 
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)
 
Chip Pearson said:
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)
Click to expand...
 
I'm having the same problem. I checked the formatting of the cells and
character length and everytrhing lines up. The table I'm pulling the data
from is a pivot table. Is this the root of my problem?
 
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.
 
Sometimes - especially with imported data - simple reformatting doesn't help.
E.g. if you want to create a real Excel text string, reformatting cells like
text doesn't do it. You have to use =TEXT(A1,"@") function to convert the
original value.

But we can give you more help if you post your data layout.

Regards,
Stefi


„Mindy†ezt írta:
 
THANK YOU THANK YOU THANK YOU!!!! I've never even heard of that 'text'
formula! I love this site~!!!
 
Back
Top