Yes, it is possible to perform a VLOOKUP consisting of multiple values and then return the sum of that result into a single cell. Here are the steps you can follow:
- First, make sure that the data you want to lookup and sum is organized in a table. For example, you could have a table with two columns: one for the city names and one for the values you want to sum.
- Next, select the cell where you want to display the sum of the lookup values.
- In that cell, type the formula "=SUM(".
- Now, click on the cell where you want to perform the VLOOKUP and type ", " (comma and space).
- Click on the cell that contains the lookup value (city name) you want to use in the VLOOKUP and type ", " again.
- Repeat step 5 for each additional lookup value you want to include in the VLOOKUP.
- Next, type the range of cells that contains the table you want to lookup from. For example, if your table is in cells A1:B10, you would type "A1:B10".
- Type a comma and then the column number of the value you want to sum. For example, if the values you want to sum are in column B of your table, you would type "2".
- Close the formula with a closing parenthesis.
- Press Enter to calculate the sum of the lookup values.
Here's an example of what the formula might look like:
Code:
=SUM(VLOOKUP("City1",A1:B10,2,FALSE),"City2",A1:B10,2,FALSE),"City3",A1:B10,2,FALSE))
In this example, the formula is looking up the values for City1, City2, and City3 in the table in cells A1:B10 and summing the values in column B.