.. does give the correct answer ...
.. I am delighted with your reply ..
... but, but you didn't click the YES button in that response ?

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"VivienW" wrote:
Thank you Max, you're a star! This does give the correct answer and thank
you for the explanation :)

I am really looking for a simpler solution for a particular reason. I need
to use VLOOKUPs but not INDEX and MATCH. Sorry to seem ungrateful - I am
delighted with your reply.

--
Cheers, V