Making a multiple choice list using reference cells

Copper Contributor

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! 

Screenshot 2023-11-04 at 2.15.46 PM.pngScreenshot 2023-11-04 at 2.15.57 PM.png

3 Replies