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

%3CLINGO-SUB%20id%3D%22lingo-sub-2209113%22%20slang%3D%22en-US%22%3EPlease%20help%3A%20I%20want%20that%20if%202%20cells%20match%2C%20paste%20adjacent%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2209113%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20sheets%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%201%20has%20%22column%20A%22%20with%20values%20and%20%22Column%20B%22%20with%20corresponding%20values%3C%2FP%3E%3CP%3ESheet%202%20has%20the%20some%20of%20the%20same%20values%20found%20in%20%22column%20A%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20that%20if%20the%20two%20values%20in%20column%20A%20match%20on%20both%20sheets%2C%20it%20should%20insert%20the%20corresponding%20value%20into%20sheet%202%20from%20%22column%20B%22%20in%20sheet%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2209113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

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