How to show a word in a drop down list instead of a number from the table
Hi i am new to all this so i apologies if i have trouble explaining myself. I have a spreadsheet with lots of drop-down lists which are imported from a table. In the table at the moment are number e.g. $390 What i am trying to do is instead of showing $390 in the drop-down list i want it to say Before 2pm. Obviously i still need the formula to work. Been to the Microsoft Store in Sydney and i am a novice and i knew more than the advisers who work there very frustrating. They keep saying this is beyond Excel capabilities
Hi Danny Type 1, I'm not sure
Hi Danny Type 1,
I'm not sure I understand, what is the connection between $390 & Before 2PM?
You could just use a lookup function, if there is only 1 correlating text value to each dollar value. Or use 2 different drop down cells utilizing the indirect function. This will change the available drop down options of the secondary cell in relation to value selected in the primary cell drop down?
I do not have enough information at this point to provide further assistance though.
Regards
Mark