Formula to return the value of the duplicate number

[LMill]

Hello,

I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following:

1. If the variance to on-hand in column D is zero then return the value in column C in column I. I already have an IF formula in column I that does this.
2. I need column I to do the above and: If the variance in Column D is NOT zero, I need the value that matches in either column C, E, or G. Since Cell D2 is not zero, I need cell I2 to find and list the duplicate or matching value in cells C2, E2, or G2 and return that value (which is 113,700). I cannot find a formula that will do this!

Thank you for your help!

 

[kevin9999]

Does this do it?

Book1
	A	B	C	D	E	F	G	H	I
1	Hdr1	Hdr2	Hdr3	Hdr4	Hdr5	Hdr6	Hdr7	Hdr8	Hdr9
2	23050	108,921	107,890.00	-1,031.00	113,700.00	4,779.00	113,700.00	4,779.00	113,700.00
Sheet1

Cell Formulas
Range	Formula
D2,H2,F2	D2	=C2-$B$2
I2	I2	=IF(D2=0,0,IF(OR(C2=E2,C2=G2),C2,IF(E2=G2,E2,"no match found")))

 

[LMill]

Thank you! This worked! I appreciate your help.

 

[kevin9999]

Happy to help and welcome to the forum!