How to use Vlookup
 

I need to us Vlookup to display sales figures on demand.

The data is in one worksheet the lookup table is in another.

In layman's terms how do I do this using Excel XP

The online help for VLOOKUP should be a great help. It does describe it in
terms that someone who can operate a PC can understand, and it even provides
examples.

If you can't figure it yourself you can post your ranges and such and what
you're trying to do.


"Jessica" wrote in message
...
I need to us Vlookup to display sales figures on demand.

The data is in one worksheet the lookup table is in another.

In layman's terms how do I do this using Excel XP

"Jessica" wrote:

I need to us Vlookup to display sales figures on demand.

The data is in one worksheet the lookup table is in another.

In layman's terms how do I do this using Excel XP

"Jessica" wrote:

I need to us Vlookup to display sales figures on demand.

The data is in one worksheet the lookup table is in another.

In layman's terms how do I do this using Excel XP


In lay terms the vlookup formula is a simple formula for finding a specific
criteria in one column and referencing a corrosponding entry in an adjacent
column.

The easiest way to learn how to use vlookup is to create a small table of
say 3 or 4 columns that have data in them. Then use the vlookup formula to
look at the entire table of columns and find something that matches your
specific ciriteria. The only thing to remember with vlookup is that the first
column entries must be sorted from least to greatest in order for vlookup to
operate properly. The "V" in vlookup means verticle which is why the first
column must be sorted in sequencial order. So if you make the first column a
list of numbers, say 1 to 25, they must be in order of 1 to 25, not 25 to 1
or mixed up.

Vlookup looks at the first column for the corrosponding number you put into
the formula and then selects the value in the same row in any adjacent column
you specify. To specify the column number you want simply count over from
the lookup column, e.g. 1, 2 3, etc.

Typical syntax for vlookup is =VLOOKUP(A8,A10:D21,3) where the value in cell
A8 is looked up in column A beginning at row 10 and returns the value in the
3rd column over from A or the corrosponding value in the C column.

Syntax for using vlookup in a seperate workbook looks like this:

=VLOOKUP(H2,[Example.xls]Sheet1!$A$10:$G$24,3) Where the value in cell H2 in
the worksheet where you want to display the answer is found in the
table/range in the "[Example.xls]Sheet1!" workbook range A10 to G 24, 3
columns over.

Hope this helps!