I'm not sure if its possible

Can you upload your sample file/data* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload your sample,
then paste the link into your reply here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Haz" wrote in message
...
Hi Max,
Thanks for getting back to me This works perfectly, However I forget to
mention that data in col A stops at A92 but the matching Col's E - F
continue
down to row 209. As a result this fuction is not picking up everyone. Is
it
possible to adjust this function or will i need a Vlookup now?

Many Thanks

Haz