Hi,
I didn't actually answer your question (in pm/email) re the fact that
it "doesn't show the point total in H9" etc, this is b/c the team being
looked up didn't actually win & isn't in the column therefore the
formulae return "#N/A".
Column H is just an intermediary column & can be hidden, as the points
for each team are now to be added up in column I (& the similar columns
for each team across the sheet).
hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=543500