Make two sets of columns match.

[ragingfred]

I thought I'd ask to see if it was even possible to do this before I start looking it up.

I have 3 worksheets. Two are for reports and the third is there to compare select data from each one.


What I'm trying to do is make Cell G1 match Cell A1 and if so does then check to see if cell H1 matches B1, and if they do
import the cell values from "Report2" to the appropriate locations on the "Main" worksheet.

If G1&H1 matches A1&B1 place values into J1&K1, if not check G2&H2 and see if A1&B1 matches G2&H2.
If they do, import values from A1&B1 into J2,K2.
Rinse and repeat.
Along with this I also would like cell C1 to be imported into "Main K1" if the prior cells match. K1 does not need to match I1.


Example

Main 
G1	H1	I1
101	A	XXX
102	B	XXX
103	C	XXX
104	D	XXX


Report2
A1	B1	C1
101	A	XXX
102	B	XXX
104	D	XXX


Final

Main
G1	H1	I1	J1	K1	L1
101	A	XXX	101	A	XXX
102	B	XXX	102	B	XXX
103	C	XXX
104	D	XXX	104	D	XXX

Hopefully I haven't butchered my explanation of this to much.

[alansidman]

In J1: =IFERROR(IF(AND(VLOOKUP(G1,Report2!$A$1:$C$3,1,FALSE)=G1,VLOOKUP(Main!H1,Report2!$B$1:$C$3,1,FALSE)=H1),Main!G1,""),"") and copy down
In K1: =IFERROR(IF(AND(VLOOKUP(G1,Report2!$A$1:$C$3,1,FALSE)=G1,VLOOKUP(Main!H1,Report2!$B$1:$C$3,1,FALSE)=H1),Main!H1,""),"") and copy down
In L1: =IF(AND(G1=J1,H1=K1),Report2!C1,"") and copy down