How to compare multiple columns in excel?

Question

I have two sheets having such data

sheet1 : **A** **B** **C** 752 A 752 E 752 N 984 G1 984 G2 4471 U1 4471 U2 4471 U4 4471 U5 4471 U7 4471 U8 sheet2: **A** **B** **C** 132 G 69092 227 G 29400 227 G1 2378 292 G 2088 426 G 14419 752 A 180829 752 E 719404 752 N 602180 1173 G 7361 1173 G1 13083 1619 US 108 5804 N 701 5804 SG 8 5819 CA 24 6333 AE 218 

What I need, I need to compare sheet1 and sheet2, if the columns of Sheet1 A and B correspond to the columns of Sheet2 A and B, then I want the C value (column in sheet2) to fit in column C1 of the column.

Please help me, I know how to compare only one column with another column using vlookup, but here I want to compare two columns at a time.

Thanks in advance

Answer 1

The quick and dirty way, insert another column (X) on both sheets, then add the formula to concat (A) and (B). Now use this new column (X) to vlookup the value of the column (C)