Forum Discussion
Data Validation List that displays one value and inputs another value
I'm making a journal entry worksheet that has easy reference to a chart of accounts on one of the other sheets. On the journal entry sheet, there is a dropdown list under Account Number. This dropdow...
I don't think that is possible without VBA.
You might use "10000 - Cash Account" in the data validation drop-down list (or even "Cash Account"), then use a formula in the column to the right to return 10000.