ISERROR Match 3 Results

[benntw]

I have the following formula that works exactly the way I wanted it to at the start.
=IF(ISERROR(MATCH(Sheet1!D4,Sheet2!E:E,0)),"New Description","No Change")

I have added another column on Sheet1 and was trying to add another variable to the formula above. The above formula is in Column Y. Column Z is a check to see if any new work orders have been added. What I am trying to do is change the formula in Column Y to see if Column Z says "Added?". If it does then I do not want the formula in Column Y to say "New Description". This simple formula is really kicking my butt this morning. I've tried If(Or(ISERROR and so forth. Can someone give me a hand in having the match formula look at two different areas please. Thanks for the help.

 

[Fluff]

If it does then I do not want the formula in Column Y to say "New Description"

What should it say?

 

[benntw]

What should it say?

I want it to say "No Change". If a new work order gets added it truly isn't a new description so there should be No Change. Only if and existing work order changes description I want it to say New Description. When I was comparing descriptions from two sheets it worked perfect. Getting that other variable in the mix was kicking my butt

 

[Fluff]

Ok, how about

=IF(OR(ISNUMBER(MATCH(D4,Sheet2!E:E,0)),Y4="Added"),"No Change","New Description")

 

[benntw]

Worked Perfect ! Thank you very much !

 

[Fluff]

You're welcome & thanks for the feedback.

 

[benntw]

Hate to trouble you again Fluff. Have one more scenario for you. What I am doing is dumping data from a program at least once a week. My code clears all values except Column O on "Available In R Systems" - Sheet1 . Column O is my unique value to a scope of work. Then the latest data on " TempRoser " - Sheet2 populates Sheet1 from Column O. When there is no value in Column O on Sheet1 it will added it and the rest of the data. When the value in Column O is not on the current data dump it will not populate any other columns on Sheet1. With everything blank except the unique value I know that the scope has been removed. I hope I did not make that confusing. Can you help me out again with another formula ? I tried to modify the one you gave me on my last problem.

On Sheet1 compare Column O to Sheet2. If D4 has no value then it is "Deleted". If it is on Sheet1 & not on Sheet2 then it would be "Added". If it is on Sheet1 & Sheet2 then it would be "Active".

Appreciate the help again Fluff

 

[Fluff]

As this is a significantly different question, it needs a new thread. Thanks