Vlookup Table - with L/U value as '100

[JMay]

Our Data tables (used for Vlookup in other places in our WB) contain
StNum Other1 Other2
'100 asdf wert
'200 asdf asdf
'300 ertyyt yuityui

Each of the StNum before the number have the " ' " before it to make it text,
versus a number. Only problem now is - Numbers are imported into other
sheets
off a system and EVEN THOUGH we are BEFORE HAND formatting the incoming
Range as .Columns(P).Numberformat = "@" my say 100 when used in a
=Vlookup(100, StoreList, 2, False) is bringing back the infamous #N/A since
'100 is what is in the LookUp Table.

How can this be corrected?

 

[Pecoflyer]

Hi,
you can try =Vlookup(100&"", StoreList, 2, False) which will transfor
the number 100 to text

Our Data tables (used for Vlookup in other places in our WB) contain
StNum Other1 Other2
'100 asdf wert
'200 asdf asdf
'300 ertyyt yuityui

Each of the StNum before the number have the " ' " before it to make i
text,
versus a number. Only problem now is - Numbers are imported int
other
sheets
off a system and EVEN THOUGH we are BEFORE HAND formatting th
incoming
Range as .Columns(P).Numberformat = "@" my say 100 when used i
a
=Vlookup(100, StoreList, 2, False) is bringing back the infamous #N/
since
'100 is what is in the LookUp Table.

How can this be corrected

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[JMay]

Pecoflyer,

Thanks -- You saved me!!

Jim May

Hi,
you can try =Vlookup(100&"", StoreList, 2, False) which will transform
the number 100 to text





--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster