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, 20 views)

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 !

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post