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

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)

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2010
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Slaying
• Dragons
• INDEX
• MATCH
• Functions
• Left
• Two
• way
• One
• lookup
• vertical
• horizontal
• row
• column
• orientated
• differently
• approximate
• on
• table
• sorted
• Descending
• whole
• Cell
• Reference
• Create
• Dynamic
• Range
• more
• than
• one
• different
• sheet
• CHOOSE
• functions
• Filp
• Table
• Get
• Amount
• in
• Next
• Bracket
• Select
• Random
• Value
• first
• non-blank
• arrays
• Ctrl
• Shift
• Enter
• CSE
• complex
• array
• formulas
• extracting
• data

[agermoune]

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

[ExcelIsFun]

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

[samaroon1000]

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

[ExcelIsFun]

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

[avbraga]

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

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

You are welcome!! I am glad that you liked it!

[ssian84]

You are really really great !

I LOVE YOU TO THE MAX !

Your tutorial videos are excellent and brilliant !

[ExcelIsFun]

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

[dmr450]

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.