There are lots of ways of doing this. Try the COUNTIF and VLOOKUP functions as simple way forward. The HELP on these should point you in the right direction.