Skip to content
Published September 27, 2019

Today We will explore a function which is more powerful then VLOOKUP and Simpler then INDEX MATCH Function.

This function is so powerful that it can Lookup RIGHTWARD as well as LEFTWARD. The best part about this function is its simplicity.

It’s so simple that this function has only three arguments which are:

Where- The Table Range
What- The Lookup Value
Which- Criteria

Here is the catch: By declaring only these three arguments you can lookup Multiple criteria in a single table.

Yes, You heard it right.

You can bring the value by matching multiple criteria in a table.

Download Practice File Here:


READ   Camera in Excel: Do You Know How to Use it?

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *