Forum Discussion

kortney2525's avatar
kortney2525
Copper Contributor
Nov 04, 2023

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! 

Resources