How to use INDEX MATCH in Excel for lookups | GREAT LOOKUP COMBO!
In this video, we explain the basics of the INDEX & MATCH functions, and we show how you can use the INDEX MATCH Combo to perform lookups.
We also show how you can perform a 2-way/ Two-way lookup using the INDEX MATCH Combo.
The INDEX MATCH combo is a very powerful tool in any Excel user's arsenal as they don't require that the column containing your lookup value be on the left-hand side of the dataset (Like the VLOOKUP function), and also, INDEX & MATCH functions are available on all Excel versions.
Download the Example workbook here:
https://tinyurl.com/3w6h22k2
Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd
Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9
****My online Excel Courses****
https://www.excelbonanza.com/courses/
#indexmatch #lookup #excelformula
