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   SPELLNUMBER: Convert Numbers To Words in Dollars in Excel?

Be First to Comment

Leave a Reply

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