How do I find the last row which meets criteria??

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.

DonkeyOte - thanks again.
It isn't a duplicate as I'm trying to achieve a different output related to my first post.
Can you please help me? I've done as you suggest and put ROW where ISNUMBER was in your code but it isn't doing what is needed.
Big thanks.
Colwyn.

Later: Have now done this and thank you for your help. I put the ROW before the final range and it worked just fine.