Excel has built-in functions called VLookup [Verticals Lookup] and HLookup [Horizontal Lookup]
These two functions are now most widely used formula for finding absolute and reference values from sheet.
VLOOKUP is a Vertical Lookup for searching values from first column.
VLookUp : Please create following excel sheet with data in it and write the formula / function as : =VLOOKUP(F6, $A$2:$B$6,2,0)
HLOOKUP is a Horizontal Lookup for searching values from each row.
HLookUp : Please create following excel sheet with data in it and write the formula / function as : =HLOOKUP(“*”, B2:D2,1,0)
You can also check for other important excel example here
