The MATCH function returns position 5. MATCH returns the position of a cell in a row or column. If you like you can also use the VLOOKUP function.
To answer above questions you can use below INDEXMATCH formulas.
Formula 1 for table 1. How to use INDEX and MATCH The INDEX Function. Assuming the fleet table is named sf and age is in column 7. INDEX MATCH is a lookup function which is considered by many as superior to the old-but-gold VLOOKUP function INDEX MATCH while being considered one function is actually a combination of two Excel functions INDEX and MATCH.