Vlookup incorrect #n/a error
 

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

Vlookup incorrect #n/a error
 

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

€žSJayTee€� ezt Ã*rta:

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

Vlookup incorrect #n/a error
 

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

Vlookup incorrect #n/a error
 

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?

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?

Vlookup incorrect #n/a error
 

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?

Vlookup incorrect #n/a error
 

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

Vlookup incorrect #n/a error
 

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:

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

Vlookup incorrect #n/a error
 

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

"Stefi" wrote:

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:

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

Vlookup incorrect #n/a error
 

You are welcome! Thanks for the feedback!
Stefi

€žMindy€� ezt Ã*rta:

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

"Stefi" wrote:

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:

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