Title:
Do a Two Way Lookup in Excel - Match() Index() Functions
Video:
Description: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 www.TeachMsOffice.com
Published:
31/Aug/2008
Do a Two Way Lookup in Excel - Match() Index() Functions
Video:
Description: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 www.TeachMsOffice.com
Published:
31/Aug/2008
No comments:
Post a Comment