Compare the equal negative value & enter the relevant Ref No

asokaw · Jun 15, 2020

[FONT=&quot]

[/FONT]
[FONT=&quot]I need a formula to show the REF No to be inserted in Result Column when the Amt is = to the Negative Amt as shown[/FONT]

NormS · Jun 15, 2020

Try this, assuming your table shown above is in A1:C11

Code:

=IF(B2>0,IFERROR(INDEX($A$2:$A$11,MATCH(-1*B2,$B$2:$B$11,0)),""),"")

NormS · Jun 15, 2020

I'm sure you realize this, but the formula above goes in C2 and is then filled down.