Do a Two Way Lookup in Excel – Match() Index() Functions

http://www.TeachMsOffice.com
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:

http://www.TeachMsOffice.com

Duration : 0:8:9


Technorati Tags: , , , , , , , , , , , ,

Tags: , , , , , , , , , , , ,

Leave a Reply