software

I have two spreadsheet tabs
1st tab has

A B
101 5 6
202 3 4
303 2 6

I my second tab I want to do a vlookup for the 202 and retrun the sum of A
and B in this example the number 7
Thanks
ETC

I take it that 101, 202 etc are in column A and the figures to SUM are in
columns B and C.

=VLOOKUP(A1,Sheet1!A1:C3,2,FALSE) VLOOKUP(A1,Sheet 1!A1:C3,3,FALSE)

--
Kind regards,

Niek Ottenquot;Sweetetcquot; gt; wrote in message
...
gt;I have two spreadsheet tabs
gt; 1st tab has
gt;
gt; A B
gt; 101 5 6
gt; 202 3 4
gt; 303 2 6
gt;
gt; I my second tab I want to do a vlookup for the 202 and retrun the sum of A
gt; and B in this example the number 7
gt; Thanks
gt; ETC
Awesome

--
Thanks
ETCquot;Niek Ottenquot; wrote:

gt; I take it that 101, 202 etc are in column A and the figures to SUM are in
gt; columns B and C.
gt;
gt; =VLOOKUP(A1,Sheet1!A1:C3,2,FALSE) VLOOKUP(A1,Sheet 1!A1:C3,3,FALSE)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Sweetetcquot; gt; wrote in message
gt; ...
gt; gt;I have two spreadsheet tabs
gt; gt; 1st tab has
gt; gt;
gt; gt; A B
gt; gt; 101 5 6
gt; gt; 202 3 4
gt; gt; 303 2 6
gt; gt;
gt; gt; I my second tab I want to do a vlookup for the 202 and retrun the sum of A
gt; gt; and B in this example the number 7
gt; gt; Thanks
gt; gt; ETC
gt;
gt;
gt;