| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| An Error return other than #N/A with VLOOKUP | New Users to Excel | |||
| How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
| Vlookup return multiple columns | Excel Worksheet Functions | |||
| assemble link from different cells and return value | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Linear Mode
