I’m trying to create a multi-facited product calculator. This requires selecting a couple of different product options and entering some values. I can’t seem to get more than one ‘choice’ component to work at a time.
Example of what I’m trying to do:
Select Product 1 from SheetA
Select Product 2 from SheetB
Enter Value 1
Enter Value 2
Then for the calculations, it would need to take certain values from each product with the entered values to find solution.
Thanks in advance for any help!