Please help: I want that if 2 cells match, paste adjacent cell value

[judy95]

I have 2 sheets

Sheet 1 has "column A" with values and "Column B" with corresponding values

Sheet 2 has the some of the same values found in "column A"

I want that if the two values in column A match on both sheets, it should insert the corresponding value into sheet 2 from "column B" in sheet 1

[#2]

@judy95 

In B2 on sheet 2:

=IFERROR(VLOOKUP(A2, 'Sheet 1'!$A$2:$B$1000, 2, FALSE), "")

Change Sheet 1 to the actual name of the first sheet.

Adjust the range if your list on sheet 1 has more than 1000 rows.

Then fill or copy down from B2 as far as you want.