Sorry about the delay in getting back, it took me a while to work out a
formula as i'm no expert by any means, i just like to try to give
something back to the forum for all the help i've
had..................that said..........copy and paste this in to cell
b1 then copy down, it worked for me!

=IF(ISERROR(MATCH(A1,C:C,0)),"",VLOOKUP(A1,C:D,2,F ALSE))

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=552076