| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Table - with L/U value as '100
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: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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup Table - with L/U value as '100
Hi, you can try =Vlookup(100&"", StoreList, 2, False) which will transform the number 100 to text JMay;291732 Wrote: 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: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 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 ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81507 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup Table - with L/U value as '100
Pecoflyer,
Thanks -- You saved me!! Jim May "Pecoflyer" wrote: Hi, you can try =Vlookup(100&"", StoreList, 2, False) which will transform the number 100 to text JMay;291732 Wrote: 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: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 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 ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81507 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Table Help | New Users to Excel | |||
| Vlookup table | Excel Discussion (Misc queries) | |||
| Table with VLOOKUP? | Excel Discussion (Misc queries) | |||
| Finding a vlookup table | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
