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