May 02 2023 06:31 AM
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.
May 02 2023 06:42 AM
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
=IFERROR(VLOOKUP(A2,Lookup,2,FALSE),"")
May 02 2023 06:45 AM