hi
please give me an example of vlookup function
regards
nader

Take a look in excel help menu

"nader" wrote:

hi
please give me an example of vlookup function
regards
nader

Hi

Assuming that you have a dataset as follow :
Col A--------Col B-------Col C-------Col D
Name-------Value-------Lookup-----Value Return
Alan--------100-----------Ken--------300
Joey--------200
Ken---------300
Mike--------400

and you want to find the corresponding value for Ken in col A and have
the result in D2.
=VLOOKUP("Ken",A5:B9,2,0)

Alternatively, you may want to use cell to hold the lookup value, eg
C2 hold the lookup value, ie Ken
=VLOOKUP(C2,A5:B9,2,0)
This will give you 300 in D2

I suggest that you post your problem with an example if there is one you
are currently facing with.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"nader" wrote:

hi
please give me an example of vlookup function
regards
nader

Hi,

From Help:

Description
You can use the VLOOKUP function to search the first column of a range
(range: Two or more cells on a sheet. The cells in a range can be adjacent or
nonadjacent.) of cells, and then return a value from any cell on the same row
of the range. For example, suppose that you have a list of employees
contained in the range A2:C10. The employees' ID numbers are stored in the
first column of the range, as shown in the following illustration.



If you know the employee's ID number, you can use the VLOOKUP function to
return either the department or the name of that employee. To obtain the name
of employee number 38, you can use the formula =VLOOKUP(38, A2:C10, 3,
FALSE). This formula searches for the value 38 in the first column of the
range A2:C10, and then returns the value that is contained in the third
column of the range and on the same row as the lookup value ("Axel Delgado").

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])The VLOOKUP
function syntax has the following arguments (argument: A value that provides
information to an action, an event, a method, a property, a function, or a
procedure.):

lookup_value Required. The value to search in the first column of the table
or range. The lookup_value argument can be a value or a reference. If the
value you supply for the lookup_value argument is smaller than the smallest
value in the first column of the table_array argument, VLOOKUP returns the
#N/A error value.
table_array Required. The range of cells that contains the data. You can
use a reference to a range (for example, A2:D8), 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 Required. The column number in the table_array argument from
which the matching value must be returned. A col_index_num argument 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 the col_index_num argument 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 Optional. A logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match:
If range_lookup is either TRUE or is omitted, an exact or approximate match
is returned. If an exact match is not found, the next largest value that is
less than lookup_value is returned.
Important If range_lookup is either TRUE or is omitted, the values in the
first column of table_array must be placed in ascending sort order;
otherwise, VLOOKUP might not return the correct value.

For more information, see Sort data.

If range_lookup is FALSE, the values in the first column of table_array do
not need to be sorted.

If the range_lookup argument is FALSE, VLOOKUP will find only an exact
match. If there are two or more values in the first column of table_array
that match the lookup_value, the first value found is used. If an exact match
is not found, the error value #N/A is returned.




Example 1
The example may be easier to understand if you copy it to a blank worksheet.

How do I copy an example?

Select the example in this article.
Important Do not select the row or column headers.



Selecting an example from Help

Press CTRL+C.
In Excel, create a blank workbook or worksheet.
In the worksheet, select cell A1, and press CTRL+V.
Important For the example to work properly, you must paste it into cell
A1 of the worksheet.

To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the Formulas tab, in the
Formula Auditing group, click the Show Formulas button.
After you copy the example to a blank worksheet, you can adapt it to suit
your needs.


--------------------------------------------------------------------------------

This example searches the Density column of an atmospheric properties table
to find corresponding values in the Viscosity and Temperature columns. (The
values are for air at 0 degrees Celsius at sea level, or 1 atmosphere.)


1
2
3
4
5
6
7
8
9
10
11






12






13




14




15






16
A B C
Density Viscosity Temperature
0.457 3.55 500
0.525 3.25 400
0.606 2.93 300
0.675 2.75 250
0.746 2.57 200
0.835 2.38 150
0.946 2.17 100
1.09 1.95 50
1.29 1.71 0
Formula Description Result
=VLOOKUP(1,A2:C10,2) Using an approximate match, searches for the value 1 in
column A, finds the largest value less than or equal to 1 in column A which
is 0.946, and then returns the value from column B in the same row. 2.17
=VLOOKUP(1,A2:C10,3,TRUE) Using an approximate match, searches for the value
1 in column A, finds the largest value less than or equal to 1 in column A,
which is 0.946, and then returns the value from column C in the same row. 100
=VLOOKUP(0.7,A2:C10,3,FALSE) Using an exact match, searches for the value
0.7 in column A. Because there is no exact match in column A, an error is
returned. #N/A
=VLOOKUP(0.1,A2:C10,2,TRUE) Using an approximate match, searches for the
value 0.1 in column A. Because 0.1 is less than the smallest value in column
A, an error is returned. #N/A
=VLOOKUP(2,A2:C10,2,TRUE) Using an approximate match, searches for the value
2 in column A, finds the largest value less than or equal to 2 in column A,
which is 1.29, and then returns the value from column B in the same row. 1.71


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"nader" wrote:

hi
please give me an example of vlookup function
regards
nader