Find and Replace across multiple rows and sheets

[rmstone]

Hi Everyone,

TYIA for the assistance!

I need Find and Replace to work with a little logic.

I have two-sheet workbook with related values in columns A & B in sheet 1.
Sheet 2 has a selection of values from sheet1 column B along with some other required information.

I need for replace the Column B values in sheet 2 with the A values from Sheet 1

Here are images with demo data of the two sheets:
https://imgur.com/a/4En4e5i

 

[ricardodiazjimenez]

Hi,
You can try to put the formula in Sheet 2 cell B1: = Vlookup(A1;'Sheet 2'!$A$1:$B$12;2;FALSE) and copy it to the cells below.