match data of sheet1 and Sheet2 ColumnA, if matched copy columnB of sheet1 to sheet2

I need help, and I am not sure how to use macros annd IF's

I have a huge data contains of 18,000 rows and working on two worksheets.

Both sheets has the same unique Values which is in ColumnA. I want to copy the Column B of Sheet1 to Column C of sheet 2 if ColumnA of Sheet1 and Sheet2 are the same.
Please note that I may have18,000 entries on sheet 1 and 17,000 entries on sheet 2. So I only want to copy the data that are present in Sheet 2.

Please see attached file as a test.

Thanks a lot.

-Annielle

test.xlsx

Hi ConneXionLost,

I tried it but it only apply to the first row.

Whenever I apply it to the entire row it all fills in the value same as the first row "yes"

Some data in sheet 2 are not present in Sheet 1 so that should remain blank.

Please help. Thanks a lot and I truly appreciate it.

I tried to auto-fill but it is still giving values as "yes" to te entire column.
Some data in sheet 2 are not present in Sheet 1 so that should remain blank.

Hello ConneXionLost,

Thanks a lot. It works.



I appreciate the time and effort responding to this query.

_Annielle