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 ...
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), "")
- Worked perfectly! Thanks for your help.