Forum Discussion
Assigning a number value to a drop down selection
Hello,
I have been struggling with this formula (I'm not very Excel savvy) and was wondering if someone could help me. I would like to assign specific number values to selections in a drop down list. As you can see in the photo below, I have a drop down with 3 choices. When a specific selection is made, I would like the cell to the right of it to populate with the assigned value of each selection. The table on the right of the photo is what the values should be.
+
Any help is GREATLY appreciated.
4 Replies
Let's say that the sick days drop down is in C6, and the list with the points in F7:H9.
Remove " =" from the descriptions in F7:F9, so that the values are equal to those in the drop down list.
In D6:
=XLOOKUP(C6, $F$7:$F$9, $H$7:$H$9, "")
or
=IFERROR(VLOOKUP(C6, $F$7:$H$9, 3, FALSE), "")
HansVogelaar Thanks for your response. I guess I should have given you a better picture. With your example, I attempted to plug my cells into your example formula but I still can't get it to work. Here is a better picture:
XLOOKUP only works in Microsoft 365 and Office 2021, not in older versions. The VLOOKUP formula should work:
=IFERROR(VLOOKUP(B143, $F$144:$G$146, 2, FALSE), "")
