Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
20,864
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on May 13, 2011

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
There are really about 30 example in this long video.

INDEX and MATCH How To:

1 MATCH Functions Basics (about 0:46 minute mark)
2 INDEX Basics: Two way lookup (about 9:05 minute mark)
3 One way lookup vertical (lookup Left) (about 13:07 minute mark)
4 One way lookup horizontal (about 14:50 minute mark)
5 One way lookup with lookup column and match column orientated differently (about 17:51 minute mark)
6 INDEX & MATCH to do approximate lookup on table sorted Descending (about 19:15 minute mark)
7 Lookup whole row (about 21:41 minute mark)
8 Lookup whole column (about 24:49 minute mark)
9 Lookup Cell Reference (about 26:00 minute mark)
10 Create Dynamic Range For Chart (about 26:00 minute mark)
11 Lookup from more than one table when tables are on same sheet as formula (about 36:29 minute mark)
12 Lookup from more than one table when tables are on a different sheet than the formula: CHOOSE, INDEX, MATCH functions (about 43:31 minute mark)
13 INDEX and ROWS to Filp a Table (about 47:20 minute mark)
14 Get Amount in Next Bracket (about 50:34 minute mark)
15 Select a Random Value (about 53:18 minute mark)
16 Lookup first non-blank value (about 54:24 minute mark)
17 Handle arrays that require Ctrl + Shift + Enter CSE (about 54:24 minute mark)
18 Basic lookup tool used in complex array formulas for extracting data (about 59:59 minute mark, 1 hour 1 minute 10 seconds)

  • likes, 1 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • Thank you for investing time to share your knowledge! Would you please invest more time and send me this workbook, or where can't download it. I took the whole time tutorial, but still need to work manualy to master it.

    God bless you!

    Agermoune@gmail.com

  • @agermoune , see the link under the video to download the workbook.

  • thanks a lot dear for the great effort that you did it's really useful

  • @samaroon1000 , cool! I am glad that the video is useful!!

  • Dude! no words to describe how much I appreciate these videos! Seriously, thank you.

  • You are welcome!

see all

All Comments (33)

Sign In or Sign Up now to post a comment!
  • You are welcome!! I am glad that you liked it!

  • You are really really great !

    I LOVE YOU TO THE MAX !

    Your tutorial videos are excellent and brilliant !

  • Cool! I am happy that the video can help change the game!!

  • I have to tell you that I changed a large workbook that had all sorts of vlookups to match and index... It now filters, sorts,updates soooo much faster that it's truly astonishing.

    Thanks for the Match Index video... it's really a game changer.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more