Hi, I have a list of books (TEST.XLS) which I need to compare them with (Copy of TEST.XLS) to find is is already available or not.

and those FOUNDED result from (TEST) will be copy to the Column B (Copy of TEST).

For example List A2:TEST found match with cell C2:Copy of TEST, I want C2:Copy of TEST cell value copy to B2:TEST

test.png

Thank you in advance