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
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: