I have an Excel table which contains 2 rows per person showing the
latest score and then below it the avg for the year (See example
below).
I need a formula that will lookup the ID and then return the yearly avg
for each person so that when I use filldown only the YearAvg score is
returned. I have tried using a combo of Offset and match and seem to be
close(ish!) but still can not get it to work.
=OFFSET(Score,MATCH(D6,ScoreCard!C4:C14,0),0)
ID TimePeriod Col_1 Score
1234 Nov x 5
1234 YearAvg x 4
4567 Nov x 7
4567 YearAvg x 6
Any help would be greatly appreciated.
Cheers
--
Sweenster
------------------------------------------------------------------------
Sweenster's Profile:
http://www.excelforum.com/member.php...o&userid=29302
View this thread:
http://www.excelforum.com/showthread...hreadid=490182