Its an small assignment to be done by using excel and VB, by writing some macros, using excel commands like VLOOKUP, if else etc.
This will take hardly 3-4 hours to complete.
Blancer.com Tutorials and projects
Freelance Projects, Design and Programming Tutorials