Word that can make a number appear in another cell

Copper Contributor

I'm trying to get a number to appear in a cell based on a word selected from a drop down list in another cell. Can this be done?


For example:


In D5 I select the word landfilled. In F5, I want the number 0 to appear.

In D6 I select the word reused. In D6, I want the number 100 to appear



1 Reply
Do you have a list of words and the values you want to show in case such a word was selected? Have a look at Help about the XLOOKUP formula, it should do what you need.