Match & Index function

kilroyscarnival · #3 03-23-2023, 12:10 PM

Quote:

Originally Posted by chelsea92

Is there a good tutorial and/or practice site to help with how to learn and utlize the Match and Index function? I currently use VLOOKUP for large sets of data, and would like to learn how to use the Match & Index function to see if it would be a better choice.

Some of my favorites on YouTube:

Leila Gharani: https://youtu.be/F264FpBDX28 and https://youtu.be/ontXHp9cwOQ

Kevin Stratvert: https://youtu.be/6JhbY8Mku1A

Mynda at MyOnlineTrainingHub: https://youtu.be/pP7AMLJa0Vc
(this is more on the INDEX function overall)

If you have a later version of Excel, check out XLOOKUP also. I use it in Office 365.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index Match Function with a Date	Priyantha Gamini	Excel	9	02-03-2023 10:39 PM
Index and Match Function	mismag	Excel	5	05-29-2019 11:26 AM
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM