VLOOKUP USING 2 LOOK UP VALUES
 

Try this - FORMULA FOR CELL E6 IS
=IF(ISERROR(VLOOKUP(D6,B:C,2)),(VLOOKUP(D6,A:C,3,) ),(VLOOKUP(D6,B:C,2)))
and then drag down
A B C D E
1 1 5 a
2 2 6 b
3 3 7 c
4 4 8 d
5 5 9 e
6 1 a
7 2 b
8 3 c
9 4 d
10 5 a
11 6 b
12 7 c
13 8 d
14 9 e


--
Regards
Mort
Australia


"Jay Trull" wrote:


I am trying to use VLOOKUP for both columns A&B and I get the "#value!"
error in the cell with the formula. This is the formula I am using:
=VLOOKUP(A1:B1,table_array,3,false) If I use just column A:
=VLOOKUP(A1,table_array,3,false) it works but I get 0.14 as the result. How
do I write this so I can lookup both A&B. Thanks

A B C
RA-2 20 0.14
RA-2 30 0.17
RA-2 40 0.2
RA-2 50 0.22
RA-2 60 0.24
RA-4 20 0.28
RA-4 30 0..35
etc. etc. etc..