| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error - Incorrect Function | Excel Discussion (Misc queries) | |||
| vlookup gives incorrect results | Excel Worksheet Functions | |||
| Incorrect Formula Error | Excel Discussion (Misc queries) | |||
| vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
Hybrid Mode
