Refreshing cell value of drop down lists
Cell1 has a display value of Medium.
Drop down list has options of High, Medium and Low
Cell2 has a formula that displays 9 if cell1 value is High, 5 if cell1 value is Medium, and 1 if cell1 value is low. Cell2 is currently showing value of 1 instead of the expected value of 5.
If I refresh all cell formulas [CTRL-ALT-F9] nothing changes.
If I select cell1 and choose the existing value of Medium from the drop down list, then cell 2 automatically updates.
How do I get the hundreds of formulas within my spreadsheet to 'pick up' the displayed values of my drop down lists?
Thanks in advance