Match based on three criteria

0

Is there a way to match based on three criteria? 

On Tab "Master" - I need to match Column G (Create Node) to column D (Queue) and Column B (Non End.Status) to see if there is a change in what is on tab "Previous Day Data" for Column G (Create Node) to column D (Queue) and Column B (Non End.Status)

It can be two different formulas if needed and most likely needs to be? Because it based on two different changes in column D (Queue) and Column B (Non End.Status)

I need the return to be in Column H or Column H and Column I (Range 2-8085)

Answer
Discuss

Answers

0
Selected Answer

The formula below will return a blank cell if values in the previous data are identical, "Changed" if they are not, and #N/A if the Create Node wasn't found. It checks both criteria.

=IF(AND(INDEX('Previous Day Data'!$B:$B,MATCH($G2,'Previous Day Data'!$G:$G,0))=$B2,INDEX('Previous Day Data'!$D:$D,MATCH($G2,'Previous Day Data'!$G:$G,0))=$D2),"","Changed")

The variation below will display a blank if the Create Node wasn't found and "Changed" or "No change" as appropriate.

=IFERROR(IF(AND(INDEX('Previous Day Data'!$B:$B,MATCH($G2,'Previous Day Data'!$G:$G,0))=$B2,INDEX('Previous Day Data'!$D:$D,MATCH($G2,'Previous Day Data'!$G:$G,0))=$D2),"No change","Changed"),"")
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login