How to do a two way lookup in excel. This tutorial teaches you how to lookup a value in a table based on two separate parameters. It is similar to the Vlookup and Hlookup but this allows you to make a more versatile lookup function.
This tutorial expects you to have at least a general understanding of the Match() and Index() functions.
To get the spreadsheet used here and for more information including free macros, forums, and keyboard shortcuts, go to:
Duration : 0:8:9