Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2071550%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071550%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20sheets%20of%20data%20with%20similar%20data%20that%20I%20need%20to%20cross%20reference%20to%20see%20if%26nbsp%3B%3C%2FP%3E%3CP%3EA2%20in%20sheet%20one%20matches%20A2%20in%20sheet%20two%3C%2FP%3E%3CP%3Ealso%20that%3C%2FP%3E%3CP%3EC2%20in%20sheet%20one%20matches%20D2%20in%20sheet%20two%3C%2FP%3E%3CP%3Eand%20if%20they%20do%20then%20copy%20G2%20from%20sheet%20two%20in%20to%20sheet%20one%20H2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20a%20number%20of%20formulas%20but%20can%20only%20get%20the%20first%203%20line%20to%20work%20and%20have%20large%20amount%20of%20data%20that%20needs%20checking.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20really%20appreciate%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2071550%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have two sheets of data with similar data that I need to cross reference to see if 

A2 in sheet one matches A2 in sheet two

also that

C2 in sheet one matches D2 in sheet two

and if they do then copy G2 from sheet two in to sheet one H2

 

Tried a number of formulas but can only get the first 3 line to work and have large amount of data that needs checking.

 

Would really appreciate help. 

0 Replies