example;

sheet1;A2:A10 and sheet2;A2:A10 contain the same unique values
sheet1;B2:B10 contains no unique values
sheet2:B1 contains a value

I need a formula that will return a match to correspond with sheet2;B1 and
sheet1;B2:B10 and if found return it in sheet2;B2:B10
Bearing in mind that sheet1;A2:A10 and sheet2;A2:A10 must also match

Thank you if you can be of help.