Excel MATCH Function Tips

Performing The Three Dimensional Lookup

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.

How To VLOOKUP Data For An Entire Month

Consider a case where you have a table like below and want to fetch the data for a single month.

Looking Up Number Values

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.

Two Way Lookup With Vlookup

We came across situation we have to look for values both horizontally and vertically.

Using Index-Match Combination To Ease Up Lookup Process

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

MATCH- Excel 2016 Function

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

How to use Vlookup with Exact Match

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.