Forum Discussion
adding value to items in a dropdown list and having value populate in a different cell
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 remova...
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),"")
- Thanks for the advice I'm about to try it out. I'll let you know if it worked for me.
