That is as close to a work of art as I have seen as far as excel formulas go. Or some type of operational mathematics poetry. Either way, both subject matters make my head spin, leaving me incredibly frustrated and confused.
I decided to track the steps using the excel formula operators and wrote them down and attached them to this response, simply to show that I am attempting to understand it and not just sitting back and having you do all the work for me. I would like to be able to construct these on my own as well.
I do understand the theory behind constructing the formulas, such as getting excel to identify the cells you are looking for by attaching a number or word value that only those cells have in common [For example, a "1" or "FALSE"], and then instructing excel to return the text from the first intersecting row that has a cell value of "1" or "FALSE," depending on what you want to accomplish. Unfortunately, I just get terribly confused in the process as this is not a particular strength of mine!
Would you mind explaining the logic in plain English from each step to the next so I can understand how you applied the theory to make the formula work as I had requested? I would be happy to make a new topic post and send you the link as that might be considered a better way to help others who struggle applying these same concepts in excel.
Thanks a ton,