software

vlookup only accepts one value. You could either create another column in
your table that comines the two columns (ex: in C1: =A1amp;quot;;quot;amp;B1) then embed a
similar concatenation in your lookup
(=vlookup(A1amp;quot;;quot;amp;B1,table_cols_3_and_4,2,false). Or, if the combination of A
and B is always unique and you're returning a numeric value, you could use
sumproduct:
=sumproduct(--(table_column1=A1),--(table_column2=B1),table_column3)

quot;Jay Trullquot; wrote:

gt;
gt; I am trying to use VLOOKUP for both columns Aamp;B and I get the quot;#value!quot;
gt; error in the cell with the formula. This is the formula I am using:
gt; =VLOOKUP(A1:B1,table_array,3,false) If I use just column A:
gt; =VLOOKUP(A1,table_array,3,false) it works but I get 0.14 as the result. How
gt; do I write this so I can lookup both Aamp;B. Thanks
gt;
gt; A B C
gt; RA-2200.14
gt; RA-2300.17
gt; RA-2400.2
gt; RA-2500.22
gt; RA-2600.24
gt; RA-4 20 0.28
gt; RA-4 30 0..35
gt; etc. etc. etc..
gt;