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
"c19ufc" <c19ufc.2cq340_1155882602.7438[ at ]excelforum-nospam.com> wrote in message
news:c19ufc.2cq340_1155882602.7438[ at ]excelforum-nospam.com...
[Quoted Text] > > 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. > > > -- > c19ufc > ------------------------------------------------------------------------ > c19ufc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37700> View this thread: http://www.excelforum.com/showthread.php?threadid=572957>
|