BInterest

H in the Hlookup function stands for the Horizontal. i.e. row wise lookup function in excel. It searches the value in the rows of table and returns the value in the same column in an table from the row you have specified during the lookup function syntax. More simpler way to understand the same would [...]

In Excel 2007, VLOOKUP Function search for a value in the 1st column of the table in study and returns the corresponding value in the same row from another column in table in study in the Vertical Direction. VLOOKUP FUNCTION can be used when you are in need of the searching the specific value for [...]