Forum Discussion
Why is the CHOOSE function not working?
I have a spreadsheet with 3 entry fields: B23 | Dropdownlist with 3 options (products) C23 | Width D23 | Height In cell E23 I would like to automatically calculate the price based on a matrix ...
First of all, the CHOOSE function is doing it's best to work; it's virtually impossible that it's Excel that''s at fault here; far more likely is that it's your USE of the CHOOSE function that's not working. Or so I suspect.
But it's hard to diagnose with only your description of what it is that your formula has to work with. In particular, we can't visualize how the "matrix price table" is organized, the source of the data you want to retrieve.
Unless this is something that's highly confidential, would you be willing to post a copy of the spreadsheet itself on OneDrive or GoogleDrive, with a link pasted here that grants access to it. I'm quite confident that a solution will be readily produced
- I uploaded a test file to Dropbox. You can find the link here:
https://www.dropbox.com/scl/fi/l1gnjubum6uvmhb5hpnxt/TableLookup.xlsx?rlkey=1rnnb5p2g8hhrizz9o1xbb231&dl=0
I know I'm not that far from a working solution, but your expertise would be very much appreciated to get this working. Looking forward to it!
