**Learn How to Lookup And Sum Column in Microsoft Excel **

The main purpose of this formula is to lookup and return the sum of a column. Here we will learn how to perform lookup and sum columns in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the INDEX, MATCH, and SUM functions you can able to perform lookup and return the sum of a column.

So, with the help of this formula, you can able to perform lookup and sum columns in the given data range in the workbook in Microsoft Excel.

**General Formula to Lookup And Sum Column**

=SUM(INDEX(data,0,MATCH(val,header,0)))

** **

**The Explanation to Lookup And Sum Column**

So we know that with the help of the given formula above you can able to lookup and return the sum of a column. Here we will learn how to perform lookup and sum columns in the given data range in the workbook in Microsoft Excel.

As we know that at the core of this formula uses the INDEX and MATCH function in a special way to return a full column instead of a single value.

Working from the inside out, the MATCH function is used to find the correct column number for the fruit. So now you have learned how to perform lookup and sum columns in the given data range in the workbook in Microsoft Excel.