Excel Lookup Series #12: INDEX & MATCH functions Example 2!

See how to use the INDEX & MATCH functions together when VLOOKUP or LOOKUP will not do the job! See how use the INDEX & MATCH functions together to look up items to the left of the lookup column when VLOOKUP will not do this! See how use the INDEX & MATCH functions together to look up an Exact Match items to the left of the lookup column when LOOKUP will not do this!

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.

Category:

Science & Technology

Tags:

• Excel
• INDEX
• MATCH
• VLOOKUP
• LOOKUP
• function
• formula
• up
• values
• to
• left
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[TheDeathsuponus]

thanks again

[ExcelIsFun]

@TheDeathsuponus , you are welcome again!!

[LiuWanfei]

you r the best and these are amazing videos! Thank you so much!!

[ExcelIsFun]

@LiuWanfei , You are welcome!

[ondogagita]

ur the best tutor!

[ExcelIsFun]

@ondogagita , Thanks! I am glad that you like the video!

[dizzydave04]

You're my HERO!!!

[ExcelIsFun]

I am glad that the video helped!

[chelseafcman2]

I've been looking for these formula's for ages, cheers mate.

[ondogagita]

ur the best tutor!

[ExcelIsFun]

I am glad that it helps!