The Lookup Function
Purpose: This function is used to retrieve data from a specific column (VLOOKUP)or row (XLOOKUP) in a table.
How to use the VLOOKUP function: