Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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)

excelformulas-functions
MS Office Version: Sroncey21
posted by: Sroncey21 (rep: 66) on Mon Nov 19, 2018 at 2:56 pm
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"),"")
posted by: Variatus (rep: 4889) on Mon Nov 19, 2018 at 8:40 pm
Discuss


Answer the Question

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