T
TrevorC
I have two sheets where I need to match up three values. If the values from
Row 1 of Column B, R and U on Sheet 1 matches the value of Columns C, AE and
AX on sheet 2 (any row), I want the word Match to appear and if all three
conditions are not met, Investigate should appear.
Here is a disaster formula I have put in so far
=IF($B1=Sheet2!C2:Sheet2!C30000)AND(IF($R1=Sheet2!AE2:Sheet2!AE30000))AND(IF($U1=Sheet2!AX2:Sheet2!AX30000)),"MATCH","INVESTIGATE")
Any assistance is appreciated.
Row 1 of Column B, R and U on Sheet 1 matches the value of Columns C, AE and
AX on sheet 2 (any row), I want the word Match to appear and if all three
conditions are not met, Investigate should appear.
Here is a disaster formula I have put in so far
=IF($B1=Sheet2!C2:Sheet2!C30000)AND(IF($R1=Sheet2!AE2:Sheet2!AE30000))AND(IF($U1=Sheet2!AX2:Sheet2!AX30000)),"MATCH","INVESTIGATE")
Any assistance is appreciated.