how to generate data from a list on excel from another worksheet?
 

hi, i'm stuck.

I'm trying generate a data from a list on excel. Basically I have a table
on one worksheet and I have a list on another selecting the first value in
each row. This bit works fine.
What I am trying to do is generate the rest of the data on that row for the
thing I select from the list.

Please Help!!

how to generate data from a list on excel from another worksheet?
 

Hi Carole

I think you need VLOOKUP. say you have the following table named SalesTeam
in A1:B5

Ref Sales Person
Jne Jane Willoughby
Jon John Slazinger
Ptr Peter Atherton
Tom Tomas Radzinski

If you type jne (the value to look up) in say d2 and
=VLOOKUP(D2,SalesTeam,2,0) in E2. E2 will return Jane Willoughby. Change the
2 to 3 in F2 to add another column to return and so on.

The table must be sorted on the ref column for LOOKUP to work correctly. If
the lookup value is not in the table Excel returns #N/A

Regards
Peter

"carole" wrote:

hi, i'm stuck.

I'm trying generate a data from a list on excel. Basically I have a table
on one worksheet and I have a list on another selecting the first value in
each row. This bit works fine.
What I am trying to do is generate the rest of the data on that row for the
thing I select from the list.

Please Help!!

how to generate data from a list on excel from another workshe
 

I tried what you said and it works now.
Thank you very much.

Carole x

"Billy Liddel" wrote:

Hi Carole

I think you need VLOOKUP. say you have the following table named SalesTeam
in A1:B5

Ref Sales Person
Jne Jane Willoughby
Jon John Slazinger
Ptr Peter Atherton
Tom Tomas Radzinski

If you type jne (the value to look up) in say d2 and
=VLOOKUP(D2,SalesTeam,2,0) in E2. E2 will return Jane Willoughby. Change the
2 to 3 in F2 to add another column to return and so on.

The table must be sorted on the ref column for LOOKUP to work correctly. If
the lookup value is not in the table Excel returns #N/A

Regards
Peter

"carole" wrote:

hi, i'm stuck.

I'm trying generate a data from a list on excel. Basically I have a table
on one worksheet and I have a list on another selecting the first value in
each row. This bit works fine.
What I am trying to do is generate the rest of the data on that row for the
thing I select from the list.

Please Help!!

how to generate data from a list on excel from another workshe
 

Carole

Your'e welcome

Regards
Peter

"carole" wrote:

I tried what you said and it works now.
Thank you very much.