Suggest the easiest way would be to use VLOOKUP in the formula in the
data sheet that looks up the team names in the first sheet and extracts
the data that way.

HTH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=565486