If you post some samples of your data structure, indicating sheet locations,
we'll have more to work with.

Post back with any other questions.

***********
Regards,
Ron

XL2002, WinXP


"Mazzeree" wrote:

Hi All

I have a list of 120 groups - Each group has a code number (which doesn't
change) and a name (which sometimes changes).
Each group is also part of larger geographic groups, purchasing groups and
training groups.

The system that i pull my data off only reports these groups by thier code
number and name (column A and B in excel). I end up putting all the other
data in by hand.

I need some way that every time i pull some data off it looks up on the
master sheet the correct names and which other groups the team is part of and
inserts these onto the spread sheet. Preferablly in columns C D and E.

Any ideas - I've looked at IF and VLOOKUP but then lost it.





I have a master list of the groups which is updated regularly