2 WAY LOOKUP IN EXCEL

2 WAY LOOKUP IN EXCEL

The ability to lookup values is a MUST have skills for all Excel users. If you cannot lookup you cannot excel in data analysis. In this article, I will show you  5  ways you can do a 2-way lookup in Excel. 1. USING SUMPRODUCT Using below sales data lookup and sum the...
LOOKUP and SUM IN EXCEL

LOOKUP and SUM IN EXCEL

Array formulas come in handy when you want to look up and sum a large amount of data. Array formulas can replace multiple normal formulas, perform multiple calculations and return a single value as a result. For example, using below Main sales data in Quantity and a...