Match and INDEX

[katiannah]

Could someone please provide a detailed explanation and perhaps a practical example of using MATCH and INDEX together to perform a lookup?

 

[AliGW]

There's a comprehensive introduction here: https://corporatefinanceinstitute.com/resources/excel/index-match-formula-excel/

 

[GraH - Guido]

Could someone please provide a detailed explanation and perhaps a practical example of using MATCH and INDEX together to perform a lookup?

The inner help of Excel does contain simple examples, that gives you a starting point of understanding what both functions do.
And here https://chandoo.org/wp/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

-->> The title being, but the text in the link is about offset. Mr Chandoo should sort that out. ;-)

VLOOKUP(), MATCH() and INDEX() – explained in plain English​