Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP for multiple colums
I am trying to return a number (1-9) for a letter.
For instance: A B C D A J S 1 B K T 2 C L U 3 D M V 4 E N W 5 F O X 6 G P Y 7 H Q Z 8 I R 9 I can do the first column, but when I try the second or third columns, I get an error value. So how can I type in a W and get it to return a 5, an I to return a 9, and so on? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using sumproduct to sum multiple colums | Excel Discussion (Misc queries) | |||
lock multiple rows and colums ? | Excel Discussion (Misc queries) | |||
vlookup colums with reference to a formula from another sheet | Excel Worksheet Functions | |||
match to colums vlookup | Excel Discussion (Misc queries) | |||
Sum mixed colums in multiple worksheets | Excel Worksheet Functions |