In a two-way lookup, you will have to get the value at the point of intersection of a column and a row.
In such a scenario, you will have two criteria to test.
We shall use the knowledge from advanced lookup functions to generate this dynamic report from an extensive database using a two-way lookup.
To better understand how this works, watch the video below
You can practice along while you watch. To help with that, download the workbook HERE
You gain a better understanding when you practice rather than just watch.
Hey!
Did you get value from this tutorial?
Kindly use the comment section to send your feedback as this will help serve you better.
Do well to share this insightful tutorial with others.
Amaka Cares!
#dexcelcoach