Basically you will have a table of data. In VLookup there are 3 things,
lookup value, table array and column. Note that the lookup value has to be on
the first column on the left of the table, no other position.

1 a f
2 b g
3 c h
4 d i
5 e j

Assuming that you have the 3 columns of data and the lookup value is 4. So
the formula will be =VLOOKUP(3,A2:D11,2)
the 3 is the lookup value, A2:D11 is the range of the table. Note that this
will include the first column so that the formula can look for the lookup
value. 2 refers to the column in the table, in this case column 2. Looking at
this,it will look for number 3 at the first column and return the number in
that row, column 2. Whihc in this case will be c.

Hope this answer you.



"excel questions" wrote:

how is v-lookup in ms excel done?