LOOKUP, VLOOKUP, HLOOKUP functions in Excel
What is Vlookup? The Excel lookup functions are used to create formulas to find the specific information you search in a table. An Excel Array Lookup allows you to lookup values in a table or array.
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.