Use a VLOOKUP to Get Values for Multiple Columns

If you're familiar with VLOOKUP, you may have usually used it to match some value and bring back another value from one cell. With some combination of function you can actually bring back multiple values with the VLOOKUP function. Take a look at this video show how to bring back values from multiple columns from a VLOOKUP. The values could then be used in another function like SUM or AVERAGE.