INDEX Function – Google Sheets
The INDEX function retrieves a value from a cell within a range.
Lookup
XLOOKUP Function – Google Sheets
The XLOOKUP function finds values in a range by row. You give the function a search term, and it returns a result. This function helps to bring information together from separate tables of data. With XLOOKUP, the return_range does not have to be to the right of the lookup_range as with the older VLOOKUP function. … Read more