Forum Discussion
RebeccaS2023
Sep 11, 2023Copper Contributor
Word that can make a number appear in another cell
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
Thanks
- JKPieterseSilver ContributorDo 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.