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,

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

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,

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,