LOOKUP, VLOOKUP, HLOOKUP functions in Excel
The Excel lookup functions are used to create formulas to find the specific information you search in a table.
Vlookup means vertical lookup
Hlookup means horizontal lookup.
Lookup will look in the full table.
The sales are recording the ID only and so our table will add the name of the sales person beside the sales and ID.