p45cal sorry for the confusion, I have attached 2 sample files test1 & test2.
test1 has Fluff's LookupCopy code (thanks Fluff btw), now, how would I modify it on the test2 file where I want to compare Column B in both sheets, then import the values from Column A in sheet 1 into Column D of sheet2.
Thanks Again
Fra