INDEX and MATCH are two functions on Excel
which can be used together for a similar purpose as VLOOKUP,
however they allow you to search anywhere in the data set. Together, these
functions allow you to find the location of the cell you are looking for within the dataset, and use this information to find the value of the cell.
Read the below article for instructions on how to get started with INDEX MATCH:
Microsoft Support Index and Match