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.