Forum Discussion
Please help: I want that if 2 cells match, paste adjacent cell value
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
1 Reply
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.
