Alright,
I can't find a formula i could use to do this and was hoping for some help.

I have a workbook with 2 sheets.
I need a formula that will compare column a from sheet 1 with column a from sheet two. If there is a value that matches, i need it to put value out of that same row in sheet two and put it on column b in sheet 1 for that particular value.

The info is confidential so i can't upload here i hope what i ask for makes sense though.