Hello all

Is it possible to make excel retrieve text from a list, I have attached an example file so i hope that helps.

In this example, I want to select from a menu 1 or more famous names and have the desired text (quotes in this example) appear in a text box that I can then copy from.

SO i can choose person a and this will bring up the full quote but also if i choose person A &B both quotes will appear in the same text box.

I hope this all makes sense.

Thanks in advanced
Peter

Attached Files

example1.xlsx (8.3 KB, 22 views)