I am new to excel but have worked with speadsheets (MS works) I need a
formula that when I enter a team name into cell A5 it automatically
inserts the team players into cells H4-19. I know its a combination of
lookup and reference. what should the formula be?


--
striker92s
------------------------------------------------------------------------
striker92s's Profile: http://www.excelforum.com/member.php...o&userid=16559
View this thread: http://www.excelforum.com/showthread...hreadid=314186