Two dimensional lookup is obvious – we have a header row and a column and we want to look at the intersection of the two criteria’s.
Consider a case where you have a table like below and want to fetch the data for a single month.
There are five methods you can use to look up number values in excel. These include SUMPRODUCT, SUMIF, AGGREGATE, LOOKUP and a combination of INDEX & MATCH.
We came across situation we have to look for values both horizontally and vertically.
Most of the time when we are stuck with lookup and return something process, we revert to VLOOKUP() and occasionally HLOOKUP(), according to the situation
The MATCH function of Excel 2016 permits users to select the position of an object in a range instead of selecting the entire actual item
Vlookup can be considered as one of the most beneficial functions offered in Microsoft Excel, which has become much useful in data analysis and data processing work.