Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup not working
I am using VLOOKUP with a range of part refs some are numeric only, some are
alphanumeric. My lookup is working fine with the alphanumerics, but not the numerics. Please help. I have tried formatting all refs in each worksheet as text to no avail. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup not working
Formatting a cell to text won't change the value.
You'll have to do more to convert the number numbers to text. If the lookup table has real text in it and there are real numbers in the value to lookup, you could change your formula: =vlookup(a1&"",..... By concatenating the empty string "" to the value, you've made it text. You could do the same thing in another column: =a1&"" and drag down then convert to values and delete the original column of data. ===== If you have to fix both the lookup table's key column and a column to match, you could use: Data|Text to columns fixed width (don't separate anything) Choose Text as the field type. (be aware that this will eliminate both leading and trailing spaces, though.) SMRE wrote: I am using VLOOKUP with a range of part refs some are numeric only, some are alphanumeric. My lookup is working fine with the alphanumerics, but not the numerics. Please help. I have tried formatting all refs in each worksheet as text to no avail. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VLOOKUP in 2003. | Excel Worksheet Functions | |||
vlookup formula not working with data on separate sheet | Excel Worksheet Functions | |||
Vlookup not working because of duplicate matches | Excel Worksheet Functions | |||
Vlookup not working in 2000 - worked in 97! | Excel Discussion (Misc queries) | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |