Hi all,
I'm no Excel expert, so forgive me for any silly questions.
I'm creating a spreadsheet to track information about clients/locations. Essentially, how I'd like it to work is this:
- Select an option from a dropdown list
- Depending on the item selected from the list, text generates in another part of the excel spreadsheet
For example - I select 'Mary' from the dropdown list in C7, then, in G4, I have written "=IF(C7="Mary", S45&T45&U45)". S,T, and U45 have facts about Mary. They read:
1. Mary's favourite colour is red.
2. Mary doesn't like bees.
3. Mary only works on weekdays.
What I would like the output to read is similar to the above, a list-like structure. How it currently presents is;'
Mary's favourite colour is red.Mary doesn't like bees.Mary only works on weekdays.
Is there a way to add a line break or something similar to my IF formula?
Also - is there a way to pull this data from another sheet or workbook?
Thankful for any advice - I've attached my workbook as an example.
Bookmarks