Using If/And/Or Statements to deliver one unique value

I am trying to develop a formula that analyzes a specific material that has multiple inputs on a datapoint (MS). There needs to be only one identified and it can be deciphered based on the criteria of the other columns that exist in the excel sheet (“MRPcn and X-Plant”). I know that I need to utilize If/And/Or statements and I have done some advanced, but can’t understand how to do it due to the fact that these duplicate rows are not spread out by blank rows and there is multiple and differential logical tests that need to be ran. So, some cells will need to be absolute referenced in the formula and others will not. 

An example of this is as follows: If a material has two material status both N2 and P2, indicating both production and engineering we look to the MRPcn and X-plant to identify what the correct single identification code needs to be under MS. I’ve conditionally formatted MRPcn so that it outputs colors respective to my legend. Ex: C43 = Production Planning = Marked with yellow whereas N0E = Engineering = Marked with blue. X-Plant consists of the same set of characters as MS, P2/N2/Etc. X-Plant and MRPcn are based on the client level within SAP so they are consistent across both rows of a material 


By: Mic Fitzgerald

40 thoughts on “Using If/And/Or Statements to deliver one unique value

  1. Kevin David Info

    In this great design of things you actually get an A just for hard work. Exactly where you confused me ended up being in all the facts. As people say, details make or break the argument.. And that couldn’t be more true here. Having said that, permit me inform you exactly what did deliver the results. Your writing is definitely incredibly convincing and that is probably the reason why I am taking the effort to opine. I do not make it a regular habit of doing that. 2nd, while I can see a leaps in logic you come up with, I am definitely not certain of exactly how you seem to unite the ideas that make the conclusion. For the moment I shall yield to your point however hope in the near future you connect your facts better.

  2. ig

    obviously like your website but you need to check the spelling on several of your posts.
    Several of them are rife with spelling problems and I in finding it very
    troublesome to tell the truth on the other hand I will certainly come back


    Pretty element of content. I simply stumbled upon your weblog and in accession capital to say that I get in fact enjoyed account your weblog posts.
    Any way I’ll be subscribing in your augment or even I achievement you get
    right of entry to constantly fast.

  4. Verla Tyce

    I’ve been surfing on-line greater than three hours these days, but I never discovered any attention-grabbing article like yours. It¦s beautiful worth sufficient for me. Personally, if all site owners and bloggers made good content material as you probably did, the net will likely be much more useful than ever before.

  5. sling tv

    It’s remarkable to pay a visit this site and reading the views
    of all friends regarding this piece of writing, while I am also keen of getting familiarity.

  6. Todd Snively

    obviously like your website but you have to test the spelling on several of your posts. Several of them are rife with spelling problems and I find it very bothersome to tell the reality however I will definitely come again again.

  7. Todd Snively

    Hello, you used to write magnificent, but the last several posts have been kinda boring… I miss your great writings. Past few posts are just a little bit out of track! come on!

  8. sling tv

    Very great post. I just stumbled upon your blog and
    wanted to say that I have really enjoyed browsing your weblog posts.
    In any case I’ll be subscribing on your rss feed and I am hoping
    you write again soon!

  9. Russ

    Hi there, just became alert to your blog through Google, and found that it is truly informative. I am gonna watch out for brussels. I’ll be grateful if you continue this in future. Many people will be benefited from your writing. Cheers!


    Do you have a spam issue on this site; I also am a blogger, and I was wanting to know
    your situation; we have developed some nice procedures and we are
    looking to exchange strategies with other folks, be sure to shoot me an email if interested.

  11. Kerrie Sosinski

    An interesting discussion is worth comment. I think that you should write more on this topic, it might not be a taboo subject but generally people are not enough to speak on such topics. To the next. Cheers

  12. quest bars cheap

    whoah this weblog is great i like studying your articles.
    Keep up the great work! You know, lots of people are looking around for this info, you could aid them greatly.


    Hey there would you mind letting me know which webhost
    you’re using? I’ve loaded your blog in 3 different browsers and I must say
    this blog loads a lot quicker then most. Can you suggest
    a good web hosting provider at a reasonable price?
    Thank you, I appreciate it!


    Hello There. I discovered your weblog the use of msn. That
    is a very neatly written article. I will be sure to bookmark it and come back to read extra of your useful information. Thanks for the post.
    I will certainly return.

Comments are closed.