Lookup Functions
Lookup functions in Excel are divided into two, VLookup (Vertical Lookup) function which look for the value in the leftmost column of the range of cells you specify in table-array and the HLookup (Horizontal Lookup) function look for value at the …