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 price in column B next to the name of "shoes AR" or so, the "second" cell from the original data you "look for"

Then you will use Vlookup by, =Vlookup(

then the value you want to "look for", = "shoes AR"

then the table of the list you need to "look up", = Column A and Column B in other sheet

then the order of the data you want to "show up" = the "Second" cell

and the last, is the range of look up, (you don't need to fill this also if not required).  

And the result will be =Vlookup(shoes AR,'other sheet'!A:B,2)

and same with Hlook up, just different direction. for look up you didnt need to add the order of the data, just add the table list you want to show up whether its in horizontal or vertical.