VLOOKUP for multiple colums
You would need 3 nested vlookups in an IF function testing first column,
then second then third
in one fell swoop you can use
=INDEX(D1:D9,MAX((A1:C9=I1)*(ROW(A1:C9))))
Where A:C9 hold the letters and D1:D9 hold the numbers.
It's an array formula and needs to be entered with ctrl + shift & enter
I would advice against using this layout, it is not a good spreadsheet
design
--
Regards,
Peo Sjoblom
"MagicBill" wrote in message
...
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?
|