kortney2525
Nov 04, 2023Copper Contributor
Making a multiple choice list using reference cells
I have a multi sheet document. I have a list of items on my reference sheet and when I am working on my other sheets, I would like to be able to see that list without having to click back over to make sure I'm using the exact same phrases that my XLOOKUP formulas are using. For example, I made a formula so that when I type "drill wheat" in the action column $11.35 automatically goes in my $ spent column. How would I make that reference sheet list come up as I'm typing on the other sheets?
Also, if you have any other tips, I'm welcome to suggestions!