Can i make excel retrieve selected text?

[peterpiper]

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

[Pecoflyer]

You can use the VLOOKUP function, but I wonder if MSWord would not be better suited , as lots of text seems to be involved?
Perhaps give it a try on that forum, macropod and his colleagues are among the best !