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

C

carole

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!!
 
B

Billy Liddel

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
 
Top