software

Sorry the message did not receive in the format as I sent it so the example
is *quobbydegouk#.
You may be able to work it out from the formula

--
Regards
Mort
Australiaquot;Mort Australiaquot; wrote:

gt; Try this - FORMULA FOR CELL E6 IS
gt; =IF(ISERROR(VLOOKUP(D6,B:C,2)),(VLOOKUP(D6,A:C,3,) ),(VLOOKUP(D6,B:C,2)))
gt; and then drag down
gt; ABCDE
gt; 115a
gt; 226b
gt; 337c
gt; 448d
gt; 559e
gt; 61a
gt; 72b
gt; 83c
gt; 94d
gt; 105a
gt; 116b
gt; 127c
gt; 138d
gt; 149e
gt;
gt;
gt; --
gt; Regards
gt; Mort
gt; Australia
gt;
gt;
gt; quot;Jay Trullquot; wrote:
gt;
gt; gt;
gt; gt; I am trying to use VLOOKUP for both columns Aamp;B and I get the quot;#value!quot;
gt; gt; error in the cell with the formula. This is the formula I am using:
gt; gt; =VLOOKUP(A1:B1,table_array,3,false) If I use just column A:
gt; gt; =VLOOKUP(A1,table_array,3,false) it works but I get 0.14 as the result. How
gt; gt; do I write this so I can lookup both Aamp;B. Thanks
gt; gt;
gt; gt; A B C
gt; gt; RA-2200.14
gt; gt; RA-2300.17
gt; gt; RA-2400.2
gt; gt; RA-2500.22
gt; gt; RA-2600.24
gt; gt; RA-4 20 0.28
gt; gt; RA-4 30 0..35
gt; gt; etc. etc. etc..
gt; gt;