Vlookup incorrect #n/a error

[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?

 

[Stefi]

We can't help without seeing your data and layout, at least a significant
excerpt.
Regards,
Stefi

„SJayTee†ezt írta:

 

[Dave Peterson]

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

 

[Chip Pearson]

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)

 

[Nsmith]

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)

 

[Nsmith]

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?

 

[Mindy]

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.

 

[Stefi]

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:

 

[Mindy]

THANK YOU THANK YOU THANK YOU!!!! I've never even heard of that 'text'
formula! I love this site~!!!

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Mindy†ezt írta: