Good breakdown of Index Match formula for sheets.

Summary of the formula:

=INDEX ( Column I want a return value from , MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0” ))

How to Use INDEX MATCH