VLOOKUP PROBLEM
I am using VLOOKUP function and even though the look up value is in the table
it is returning a #N/A. I am using FALSE so I am looking for an exact match. The vlookup IS WORKING when the look up value is mixed characters (ie: C3089, U5320,etc) but is returning #N/A WHEN the look up value is all numeric (ie: 30900,35679, etc.) The formula in the top cell is: =VLOOKUP(K2,Codes!$A$2:$B$340,2,FALSE) where K2 is a value to be looked up in the table(which is on another worksheet in workbook named "Codes" and the left most column contains the possible choices for the look-up value to match, |
VLOOKUP PROBLEM
Look at Debra Dalgleish's site for troubleshooting your =vlookup() formula: 'Excel -- Worksheet Functions -- VLookup' (http://contextures.com/xlFunctions02.html#Trouble) CLEM;326867 Wrote: I am using VLOOKUP function and even though the look up value is in the table it is returning a #N/A. I am using FALSE so I am looking for an exact match. The vlookup IS WORKING when the look up value is mixed characters (ie: C3089, U5320,etc) but is returning #N/A WHEN the look up value is all numeric (ie: 30900,35679, etc.) The formula in the top cell is: =VLOOKUP(K2,Codes!$A$2:$B$340,2,FALSE) where K2 is a value to be looked up in the table(which is on another worksheet in workbook named "Codes" and the left most column contains the possible choices for the look-up value to match, -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91337 |
VLOOKUP PROBLEM
It sounds like one of your numeric sets is actually formatted at text. Given
your description, it is probably the set that is mixed with the alpha-numerics. You can test this by using =ISTEXT(cell reference). If it returns TRUE, then you can convert the numbers you are looking up into text by using this: =VLOOKUP(""&K2,Codes!$A$2:$B$340,2,FALSE) Let me know if that works. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "CLEM" wrote: I am using VLOOKUP function and even though the look up value is in the table it is returning a #N/A. I am using FALSE so I am looking for an exact match. The vlookup IS WORKING when the look up value is mixed characters (ie: C3089, U5320,etc) but is returning #N/A WHEN the look up value is all numeric (ie: 30900,35679, etc.) The formula in the top cell is: =VLOOKUP(K2,Codes!$A$2:$B$340,2,FALSE) where K2 is a value to be looked up in the table(which is on another worksheet in workbook named "Codes" and the left most column contains the possible choices for the look-up value to match, |
VLOOKUP PROBLEM
Thanks for the info, I got it to work!!!
"CLEM" wrote: I am using VLOOKUP function and even though the look up value is in the table it is returning a #N/A. I am using FALSE so I am looking for an exact match. The vlookup IS WORKING when the look up value is mixed characters (ie: C3089, U5320,etc) but is returning #N/A WHEN the look up value is all numeric (ie: 30900,35679, etc.) The formula in the top cell is: =VLOOKUP(K2,Codes!$A$2:$B$340,2,FALSE) where K2 is a value to be looked up in the table(which is on another worksheet in workbook named "Codes" and the left most column contains the possible choices for the look-up value to match, |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com