«
»

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

Related posts:

  1. Excel Lookup Series #6: HLOOKUP Function
  2. Highline Excel Class 45: INDEX function & MATCH function 12 Unusual Examples
  3. Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values
  4. Excel Lookup Series #3: VLOOKUP Function 3rd Example
  5. Excel Name Trick #7: INDIRECT function, Names and LOOKUP

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

This entry was posted on Saturday, August 28th, 2010 at 11:17 am and is filed under Learn Excel Formulas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply