Vlookup excel

Use INDEX and MATCH in Excel and impress your boss.

Vlookup with match formula in excel

If(match excel then yes)

Index match excel

Excel if(match)

Index excel

Instead of using VLOOKUP, use INDEX and MATCH. To perform advanced lookups, you'll need INDEX and MATCH.

MATCH

The MATCH function returns the position of a value in a given range. For example, the MATCH function below looks up the value 53 in the range B3:B9.

Explanation: 53 (first argument) found at position 5 in the range B3:B9 (second argument).

In this example, we use MATCH to return an exact match so we set the third argument to 0.

INDEX

The INDEX function below returns a specific value in a one-dimensional range.

Explanation: the INDEX function returns the 5th value (second argument) in the range E3:E9 (first argument).

INDEX and MATCH

Replace the value 5 in the INDEX function (see previous example) with the MATCH function (see first example) to look up the salary of ID 53.

Explanation: the MATCH function returns position 5.

The INDEX function needs position 5.

Excel match function two columns

It's a perfect combination. If you like, you can also use the VLOOKUP function. It's up to you. However, you'll need IN

how to find a match in two excel columns

how to find a partial match in excel