Excel Lookup Series #13: INDEX & MATCH Functions Example 3!

Tags:
Colleges Community Down Drop Excel Formatting Formula Function Gel Girvin Highline Index Match Mike Names Number
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 449
  • Added: 01-May-08

See how to use the INDEX & 3 MATCH functions in one formula to look up a value from 1 of 3 different tables! Also see how adding Names & a Data Validation Drop-down List can make the INDEX & MATCH functions more accurate. Also see how to use Custom Number Formatting for a formula input number. See how to correct a formula using Formula Evaluator.

See how the Amazing INDEX function can lookup values from different tables! See how we can tell the INDEX function a Row #, a Column# & a Table# and it will retrieve a value from 1 of three different tables.

See how to make an invoice shipping charge formula when you have a complicated lookup requirement.

In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

  1. Categories: Science & Tech
Comments on

Excel Lookup Series #13: INDEX & MATCH Functions Example 3!

3 Comments | Add Comment
  • yes. that the one.

    yes. that the one.

    By shiryu008 [Affiliate User] 1219869767 Reply Spam Moderate Up Moderate Down
  • Dear shiryu008, ...

    Dear shiryu008,

    I think it is this one you are talking about:

    Excel Name Trick #7: INDIRECT function, Names and LOOKUP

    This video is part of the name series.

    Is this the video you are talking about?

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1219869481 Reply Spam Moderate Up Moderate Down
  • Mike, i think there ...

    Mike, i think there is a missed video on the lookup functions series. In the excel file there is tes "intersector operator". I could'nt find the video on the playlist. also i remarked that you aded the trick nÂș7 on the playlist. Can you check this please.

    thanks.

    By shiryu008 [Affiliate User] 1219868403 Reply Spam Moderate Up Moderate Down
3 Comments | Add Comment