Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using letter and numeric codes
I wonder if anyone can help me, I have got a spreadsheet where i want to
lookup product information using vlookup, but the problem i am having is that becuase my product codes are both numeric and letter based it does'nt work correctly. I know if i use letter or numbers on there own it works fine but I would like to use both, is there anyway to accomplish this? Cheers Alistaire |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using letter and numeric codes
That shouldn't be a problem, while the list contains unique values. Try
adding FALSE as the fourth parameter on the VLOOKUP formula, as this will disable the need of having a sorted list. Hope this helps, Miguel "LW_Greeney" wrote: I wonder if anyone can help me, I have got a spreadsheet where i want to lookup product information using vlookup, but the problem i am having is that becuase my product codes are both numeric and letter based it does'nt work correctly. I know if i use letter or numbers on there own it works fine but I would like to use both, is there anyway to accomplish this? Cheers Alistaire |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using letter and numeric codes
Cheera thats did it, i knew it would be something simple!
"Miguel Zapico" wrote: That shouldn't be a problem, while the list contains unique values. Try adding FALSE as the fourth parameter on the VLOOKUP formula, as this will disable the need of having a sorted list. Hope this helps, Miguel "LW_Greeney" wrote: I wonder if anyone can help me, I have got a spreadsheet where i want to lookup product information using vlookup, but the problem i am having is that becuase my product codes are both numeric and letter based it does'nt work correctly. I know if i use letter or numbers on there own it works fine but I would like to use both, is there anyway to accomplish this? Cheers Alistaire |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How do i lengthen an existing VLOOKUP table array? | Excel Worksheet Functions | |||
How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) | |||
How do I sort alphabetically by last letter in Excel? | Excel Discussion (Misc queries) | |||
Converting Letter Grades to Numeric | Excel Worksheet Functions |