I am making a points spreadsheet for the local race track. I've figured
out how to assign points for each heat race based on starting position
and finishing position. Now what I need is a function to pull data from
the points earned in all three heats to assign drivers a starting
position in the feature race. The formula needs to be able to recognize
which driver coincides with which score (they're on the same row.) I
thought MATCH would work, but it returned errors. I might be using it
wrong. Any ideas?

~Jonathan


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952