Consolidating worksheets in excel
In our case, we must make sure that each criteria combination only exists once in our table.
In the example on the right hand side, we would have exactly this problem: There are 3 VW Golfs in our table, so the return value is the sum of the 3 prices.
VLOOKUP is probably the best known formula for getting data from another table.
The application is fairly easy, although there are some common mistakes which people tend to make.
One more word to the case in which you got more than one search criteria and want to return text: In such case we recommend using a new search column, which combines all the search criterias.