VLOOKUP for multiple colums
Here's one possible solution:
=IF(ISNA(VLOOKUP(F11,A1:D9,4,FALSE)),IF(ISNA(VLOOK UP(F11,B1:D9,3,FALSE)),VLOOKUP(F11,C1:D9,2,FALSE), VLOOKUP(F11,B1:D9,3,FALSE)),VLOOKUP(F11,A1:D9,4,FA LSE))
--
-SA
"MagicBill" wrote:
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?
|