Help for Vlookup

[mangesh]

I have two sheets one is book 1 and other is book2.xls . In book 2 I
have Column A which has Names like x, y and z and against these name
there are certain information in column B. I also have book1.xls
Containing name of the person( x, y, and z). Now what I want if through
the help of auto filter in
book2.xls if I select name of x, all the information which has in
book2.xls against x should be automatically incorporated in book1.xls
below the name of X and so on for y and Z.
I know we can do it with the help of vlookup but i am not getting it.
Please help me.

 

[Guest]

In Book1.xls, Sheet1, cell B1, put this formula.....

=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$B,2,FALSE)

In cell C1 put this formula

=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$Z,3,FALSE)

Notice the only difference between the two is the number just before the
FALSE, which indicates which column of data you wish to retrieve from
Book2....
Continue across row one with these formulas, increasing the number by 1 each
time you change columns and then copy all of the formulas down as far as you
have data in column A...........

Vaya con Dios,
Chuck, CABGx3

 

[JennyC]

Is there anyway to transpose more than one column at a time ?

I sometimes need to merge lots of data!

Jenny

In Book1.xls, Sheet1, cell B1, put this formula.....

=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$B,2,FALSE)

In cell C1 put this formula

=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$Z,3,FALSE)

Notice the only difference between the two is the number just before the
FALSE, which indicates which column of data you wish to retrieve from
Book2....
Continue across row one with these formulas, increasing the number by 1 each
time you change columns and then copy all of the formulas down as far as you
have data in column A...........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

To just bring in data from another workbook, try just this formula in A1 and
drag it around......

=[Book2.xls]Sheet1!A1

Vaya con Dios,
Chuck, CABGx3

Is there anyway to transpose more than one column at a time ?

I sometimes need to merge lots of data!

Jenny

In Book1.xls, Sheet1, cell B1, put this formula.....

=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$B,2,FALSE)

In cell C1 put this formula

=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$Z,3,FALSE)

Notice the only difference between the two is the number just before the
FALSE, which indicates which column of data you wish to retrieve from
Book2....
Continue across row one with these formulas, increasing the number by 1 each
time you change columns and then copy all of the formulas down as far as you
have data in column A...........

Vaya con Dios,
Chuck, CABGx3