# 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)

## 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"),"")``