hgrove wrote...
...
C2:
=INDEX(Bonust,MIN(SUMPRODUCT((B$2:B$201=B2)
/COUNTIF(B$2:B$201,B$2:B$201)),ROWS(Bonus)))

Select C2 and fill down into C3:C201.
...

Typo. Change 'Bonust' to 'Bonus', so

C2:
=INDEX(Bonus,MIN(SUMPRODUCT((B$2:B$201=B2)
/COUNTIF(B$2:B$201,B$2:B$201)),ROWS(Bonus)))


---
Message posted from http://www.ExcelForum.com/