=Offset($A$1,D496-1,2)*0.5+Offset($A$1,D496-1,3)+Offset($A$1,D496-1,4)*2+Off
set($A$1,D496-1,5)+Offset($A$1,D496-1,6)-Offset($A$1,D496,7)


or
=Indirect("C"&D496)*0.5+Indirect("D"&D496)+Indirec t("E"&D496)*2+Indirect("F"
&D496)+Indirect("G"&D496)-Indirect("H"&D496)

are two ways to do your formula. In D496 you could have

=Match(C496,$A$1:$A$250,0) Change 250 to reflect the last row of the team
tables.

This should return 119 and save you having to look it up.

--
Regards,
Tom Ogilvy

jayhawk1919 wrote in message
...
So you're saying I should look it up by player name rather than row
number? And I'm not quite sure I understand what I'm supposed to do
according to what you said.

The "table" I referred to is not an actual table, just cells that have
borders drawn around them so they appear as a table.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/