Forum Discussion
mpalone111777
Jun 05, 2024Copper Contributor
seeking guidance phrasing my questions so I can use help files
I have spent hours using the help files for a project I am working on. However, since I am so new to excel, I don't know how to phrase my questions so I can use help files. I am trying to create a ...
JKPieterse
Jun 05, 2024Silver Contributor
I have made some changes and added some comments. Hope that helps?
mpalone111777
Jun 05, 2024Copper Contributor
Thank you so much! I REALLY appreciate your help! Yeah, I wanted the drop down to be a single word vs the entire text I need to use. What I want to populate are entire paragraphs, so I wanted the drop down to be a simple association without having to read 20 different paragraphs. Do you know if that is even possible?
- JKPieterseJun 06, 2024Silver Contributor
mpalone111777 You can pull other information from adjacent columns using the XLOOKUP function. Check out Help. You would add a column to the table the current validation is pulling the short string from to hold the long strings.