I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated.
If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’. If D144 is Blank and E144 contains ‘Specific Text B’ return ‘Specific Text Y’. If D144 is not blank, return D144.
I hope that makes sense. Thank you to the community in advance!
-Karen
If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’. If D144 is Blank and E144 contains ‘Specific Text B’ return ‘Specific Text Y’. If D144 is not blank, return D144.
I hope that makes sense. Thank you to the community in advance!
-Karen