compare two columns of two worksheets

Hi
I have my data as many rows and one column asume column A in sheet1.
In sheet2 I have data in column A and column B.

I need a code (or formula) keeping sheet1 as a base and compare two columns and for each data maching in column A of both worksheets bring the corresponding data in column B of sheet2 and put in column B of sheet1.

briefly fill out the sheet1 using data in sheet2

thanks in advance

hello hme_s
please attach a dummy sheet see we can see what you can, pref with an example of what you expect as a result.
Regards
Peter

Hi Peter

Thank you for your reply

As you can see in the attachment, I would like the code find equal data in columnA of sheet1 and sheet2 and copy the relevant data of columnB of sheet2 in columnB of sheet1.

For exapmle in sheet1 of attached file I copy and past the relevant data for cell A7 andA8 manually.
Hope it is clear.

thanks
Hme_s

Hi

Sorry, but the attached file in previous post was incomplete.Please refer to attachment of this post.

rgrds
Hme_s

Hi

May sombody help me.

I have attached a dummy sheet presenting my request.
Simply I need a code/Formula to compare two column and in case of equal cell to copy the row (or Just relevant cell in columnB) from one sheet to another sheet.

Thanks
Hme_s

please have a look at this.
regards
peter

Hi Peter
It is working!

Thanks a Lot.
Hme_s