Range reference and return

[PritiOne]

Hello. Hope all had a wonderful holiday!

I am looking for help on the folowing:

I have 3 defined ranges, say Range 1, Range 2, and Range 3 defined on a sheet in a workbook.
On another sheet "Input Sheet" I have a list input by a user.

I need to know how to write a formula (could be elsewhere in the workbook) so that if the user chooses at lease 1 "product" from Rang 1, and at least one "product" from Range 2, and at least one "product" from Range 3 on the "Input Sheet" a result would follow as "1% discount".

Please let me know if you need any further information & Thanks in advance for the help!!!

 

[tusharm]

Are you sure you did not mean "...You guys sure have inflated egos."? {vbg}

More seriously -- and this is probably my last post in this discussion -- remember my comment about about understanding all the behind the scenes work that XL has to do with the array formula? The one that Aladin dismissed with his one-liner about adding a comment?

Not only was that not a comprehensive list of all that is going on behind the scenes, but what is going on is so extensive that there are aspects that everyone -- myself included -- missed. I caught it last night when working on the problem. Something has been nagging me about this discussion and I decided to take one more look at it. In the process of recreating the setup one more time, I mistyped NotEligible. Try it yourself. Make just one typo in any of the range names or arguments in any of the eight (that sure has grown from the original 3, hasn't it?) boolean and implied boolean conditions you have. See what happens.

Now, do you see what I meant by the need to develop a solution that supports transparency in both the business decision making process and how XL supports that process?

Thank you all - for your help and comments. You guys sure are smart!!!