INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally

The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.