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 colum...
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.