Compare two values in two sheets and find in multiple colummns

[FRANGZC]

Lets say that i want to compare two values (C3) in two sheets {Main and secondary}, with the condition to find the same Site (Column A3) and Same Part number (B3) in the Second sheet . Additionally if the results is the exact same would like to set as "Match" if not I need the difference between of these two values Main C3:Second (C3)

 

[jtakw]

Hi,

Something like this.
Add Sheet name, change/adjust cell range/references accordingly:

Book3.xlsx
	A	B	C	D	E	F	G	H
1		SECOND				MAIN
2								VALUE
3	001A	X1	4		001A	X1	4	Match
4	001C	Z1	6		001B	Y1	5	-5
5	001B	Y1	0		001C	Z1	5	1
Sheet1088

Cell Formulas
Range	Formula
H3:H5	H3	=IF(COUNTIFS(A$3:A$5,E3,B$3:B$5,F3,C$3:C$5,G3),"Match",SUMIFS(C$3:C$5,A$3:A$5,E3,B$3:B$5,F3)-G3)

 

[FRANGZC]

Thank you so much