simplify nested if statement

I am trying to simply an if statement. I have a attached a spreadsheet with dummy information. In the attached example, I have names of clients listed in rows and names of products purchased listed in columns. For each client, I want to list in a cell the products that were purchased. The problem I am having is for three products, I have 7 possible combinations and I do not want to write 7 if statements. For the spreadsheet with real data, there is over 10 products and the number of possible combinations to many for excel to handle. Any help is appreciated. Thanks.

I tried that formula in my spreadsheet but I am receiving a #NAME error. Can you take a look at the formula again? Thanks.

Sorry - overlooked that part for your message. This formula will not work for me. I don't have Admin Rights to install the addin and IT won't give me Admin rights. Can you suggest alternative way to accomplish what I am trying? Thanks

Originally Posted by maacmaac

I am trying to simply an if statement. I have a attached a spreadsheet with dummy information. In the attached example, I have names of clients listed in rows and names of products purchased listed in columns. For each client, I want to list in a cell the products that were purchased. The problem I am having is for three products, I have 7 possible combinations and I do not want to write 7 if statements. For the spreadsheet with real data, there is over 10 products and the number of possible combinations to many for excel to handle. Any help is appreciated. Thanks.

See the attached