Learn to use VLOOKUP in Excel

The VLOOKUP and HLOOKUP formula in Excel allow you look up a value in one column or row and return a corresponding value from a different column or row. VLOOKUP is a vertical lookup and HLOOKUP is a horizontal lookup The table of data below contains 4 columns.¬† A Product Number, the Supplier, the quantity […]