VLOOKUP

VLOOKUP is short for "vertical lookup" and is the function used to retrieve data from a table or look up specific information when placed in different columns throughout an Excel spreadsheet.