ExcelBanter - How do you return the sum of two cells in a vlookup?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do you return the sum of two cells in a vlookup? (https://www.excelbanter.com/excel-worksheet-functions/67348-how-do-you-return-sum-two-cells-vlookup.html)

Sweetetc

How do you return the sum of two cells in a vlookup?

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

Niek Otten

How do you return the sum of two cells in a vlookup?

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 Otten

"Sweetetc" wrote in message
...
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

Sweetetc

How do you return the sum of two cells in a vlookup?

Awesome

--
Thanks
ETC

"Niek Otten" wrote:

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 Otten

"Sweetetc" wrote in message
...
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

All times are GMT +1. The time now is 09:03 AM.