VLOOKUP
 

Can you provide simple step by step instructions to do a vlookup for two
different
spreadsheets?

VLOOKUP
 

One simple way to teach yourself would be to
in a cell type
=vlookup(3,
then goto the tab and lookup table you wanthighlight ithit enter
complete the ,2,false) of the formula


--
Don Guillett
SalesAid Software

"KOL" wrote in message
...
Can you provide simple step by step instructions to do a vlookup for two
different
spreadsheets?

VLOOKUP
 

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html

KOL wrote:

Can you provide simple step by step instructions to do a vlookup for two
different
spreadsheets?

--

Dave Peterson

VLOOKUP
 

YES

The Allen Wyatt version is what got me going and I don't think that I'll be
able to top him:

http://exceltips.vitalnews.com/Pages..._Function.html

But let me go ahead and give it to you in my english.

Take your cell you want to have the value posted to and type in =vlookup(

Then you'll see excel 'guide' you to what you need to do next (Excel2003)

Now it wants the lookup value == What number do you want it to find?

Usually you've got that number in a cell so you'll probably use a cell
reference like A2

Now your formula looks like =vlookup(a2,

After the , excel is going to need to know where to look it up. Go ahead
and use your mouse. Select the entire table.

Make sure the left column is has the value you're looking up somewhere in it.

Once you've got the table selected press the ,

DO THIS BEFORE YOU CHANGE SHEETS!!!

now our formula looks like =vlookup(a2,sheet2!A1:B6,

After this , it wants to know what column you want spit back at you.

Starting on your table you selected count your columns. Column 1 contains
the data that you looked up and keep counting from there.

=vlookup(a2,sheet2!A1:B6,5,

We put one more comma in and then come to a 'weird' feature.

Vlookup will find the closes value if you want it to. If you're looking for
the exact value you'll have to tell it to turn this feature off. I usually
do.

=vlookup(a2,sheet2!A1:B6,5,false)

That's it!

Now if you're going to copy this for multiple cells that all reference the
same range make sure you make the range absolute. To do this use the $

=vlookup(a2,sheet2!$A$1:$B$6,5,false)

This last one you can cut and paste but the table you selected will be the
same






"KOL" wrote:

Can you provide simple step by step instructions to do a vlookup for two
different
spreadsheets?

VLOOKUP
 

SELF CORRECTION

There aren't 5 columns between A1:B6

The formula should read

=vlookup(a2,sheet2!A1:E6,5,false)
or
=vlookup(a2,sheet2!A1:B6,2,false)

with the final version looking like:

=vlookup(a2,sheet2!$A$1:$E$6,5,false)
or
=vlookup(a2,sheet2!$A$1:$B$6,2,false)

I hope this innaccuracy doesn't throw anyone off.



"Jacob_F_Roecker" wrote:

YES

The Allen Wyatt version is what got me going and I don't think that I'll be
able to top him:

http://exceltips.vitalnews.com/Pages..._Function.html

But let me go ahead and give it to you in my english.

Take your cell you want to have the value posted to and type in =vlookup(

Then you'll see excel 'guide' you to what you need to do next (Excel2003)

Now it wants the lookup value == What number do you want it to find?

Usually you've got that number in a cell so you'll probably use a cell
reference like A2

Now your formula looks like =vlookup(a2,

After the , excel is going to need to know where to look it up. Go ahead
and use your mouse. Select the entire table.

Make sure the left column is has the value you're looking up somewhere in it.

Once you've got the table selected press the ,

DO THIS BEFORE YOU CHANGE SHEETS!!!

now our formula looks like =vlookup(a2,sheet2!A1:B6,

After this , it wants to know what column you want spit back at you.

Starting on your table you selected count your columns. Column 1 contains
the data that you looked up and keep counting from there.

=vlookup(a2,sheet2!A1:B6,5,

We put one more comma in and then come to a 'weird' feature.

Vlookup will find the closes value if you want it to. If you're looking for
the exact value you'll have to tell it to turn this feature off. I usually
do.

=vlookup(a2,sheet2!A1:B6,5,false)

That's it!

Now if you're going to copy this for multiple cells that all reference the
same range make sure you make the range absolute. To do this use the $

=vlookup(a2,sheet2!$A$1:$B$6,5,false)

This last one you can cut and paste but the table you selected will be the
same






"KOL" wrote:

Can you provide simple step by step instructions to do a vlookup for two
different
spreadsheets?