adding value to items in a dropdown list and having value populate in a different cell

Copper Contributor

Hello. I've created a dropdown list in Excel and I want to add value to the list and have it populate in a different cell. For example, the list has 4 inputs (present, absent, suspended, class removal). Present=2, absent=-2, suspended=0, and class removal=1. I want to be able to pick from this list in cell A2 and have the value populate in cell A4. If anyone can help it would be greatly appreciated.

2 Replies


I'd create a small lookup table, with the drop down items in the first column and the corresponding values in the second column. The table can be on the same sheet or on another sheet, even a hidden one.


Name the table Lookup (or something similar).

You can then use



Thanks for the advice I'm about to try it out. I'll let you know if it worked for me.