Prev: Macro button gets bigger when clicked
Next: excel 2003
From: excel questions excel on 27 May 2010 16:14
how is v-lookup in ms excel done?
From: Jacob Skaria on 27 May 2010 16:23
You have missed to mention about Range_lookup

(Taken from Excel help)

The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when
your comparison values are located in a column to the left of the data that
you want to find.

Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value The value to search in the first column of the table array
(array: Used to build single formulas that produce multiple results or that
operate on a group of arguments that are arranged in rows and columns. An
array range shares a common formula; an array constant is a group of
constants used as an argument.). Lookup_value can be a value or a reference.
If lookup_value is smaller than the smallest value in the first column of
table_array, VLOOKUP returns the #N/A error value.

Table_array Two or more columns of data. Use a reference to a range or a
range name. The values in the first column of table_array are the values
searched by lookup_value. These values can be text, numbers, or logical
values. Uppercase and lowercase text are equivalent.

Col_index_num The column number in table_array from which the matching
value must be returned. A col_index_num of 1 returns the value in the first
column in table_array; a col_index_num of 2 returns the value in the second
column in table_array, and so on. If col_index_num is:

Less than 1, VLOOKUP returns the #VALUE! error value.
Greater than the number of columns in table_array, VLOOKUP returns the #REF!
error value.

Range_lookup A logical value that specifies whether you want VLOOKUP to
find an exact match or an approximate match:



--
Jacob (MVP - Excel)


"ck13" wrote:

> 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?
 | 
Pages: 1
Prev: Macro button gets bigger when clicked
Next: excel 2003