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 ...
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.