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 ...
Tried to fix it, but no success. Maybe you can give it a try in the XLS file I shared?
You cannot use CHOOSE here - it expects a numeric argument.
See the attached version. It's not very interesting since the values in the three ranges are identical...
Thx Hans for the input!
However, when i download and open your file, i still get an (another) error message. In preview mode it says 'error 504'. When opening in Excel it says 'By moving or deleting cells, an invalid cell reference has occured. Or the function gives a reference error as result'.Do you have this on your side too?
I'm sorry, I don't know why you get that error message. I can open the workbook without problems (I tested it again just now).
- Found it!! It was a translation issue English to Dutch. (#Headers should be #Kopteksten)