Please Help

C

c19ufc

Hi Guys.


I'm new here, done a lil excel work at college and along time ago now.


I thought i would try and help a friend at work out, and got in a lil
to deep i think.


Right this is what i need if you can help.


He has decided once again to do a sun dream team for us employees, this
is going to entale between 15-20 (ish) teams,

I thought we could have a spread sheet for each team.

now i thought a main database for ALL players that we will use, then to
change ALL the players points he just has to go to the main database and
as he changes each 1 it auto matically changes all the others ????


is this possible and ifso how or would some 1 please help.


thanks.
 
B

Bernie Deitrick

Use a VLOOKUP formula keyed to the player name on the sheet, to look up the points from the main
database, along the lines of

=VLOOKUP(A1,'Main Database'!$A$1:$E$100,5,FALSE)

where A1 has a value that would match column A of the main database, and you want the value from the
5th column returned.

HTH,
Bernie
MS Excel MVP
 
Top