Colwyn, why have you marked the below Q Solved if not so ?

http://www.excelforum.com/excel-work...-criteria.html

Please do not duplicate posts.

You can adapt the solution provided for returning score by returning the ROW of the range as opposed to the score in the final parameter of the LOOKUP.