20 Alternative Excel methods to VLOOKUP.     Function VLOOKUP – Find and return related data from the other table. Structured reference: [@CURRENCY] –  Lookup