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