Assigning a number value to a drop down selection

[crpell]

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.

[#2]

@crpell 

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), "")

[#3]

@Hans Vogelaar 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:

[#4]

@crpell 

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), "")

[#5]

Worked perfectly! Thanks for your help.