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!A X30000)),"MATCH","INVESTIGATE")

Any assistance is appreciated.

You need to look in the help index for the correct syntax for AND

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TrevorC" wrote in message
...
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!A X30000)),"MATCH","INVESTIGATE")

Any assistance is appreciated.

Maybe...

=if(isnumber(match(1,($B1=Sheet2!C2:C30000)*($R1=S heet2!AE2:AE30000)
*($U1=Sheet2!AX2:AX30000))),"MATCH","INVESTIGATE")

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.

TrevorC wrote:

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!A X30000)),"MATCH","INVESTIGATE")

Any assistance is appreciated.

--

Dave Peterson