Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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