Look up Formula
There was this request to teach or explain how to use vlookup in 30 minutes,... oh well,... the time will be depend on how concentrate or focused you are,... Explanation: In the Excel Formula, there's 3 type of look up, the "vlook up", "lookup" and "hlook up". Through, all have the same function. it is to "look up" for something you want to "look for". The V or H is mean for the direction of the data you want to "look up". If the data you want to look is in column or (Vertical) then use Vlookup and if the data is in row then use (Hlookup). Example, you want to look for the price of "shoes AR" in the list of "shoe price list" in other sheet. The "look up" data are in column, when all shoes name are detailed in Column A, and the price is on Column B. In manual way, you will need to find the name "shoes AR" in the "shoe price list" first, and then you will figure out the pri...