Search for a text in a cell and give the outcome later

E

Elton Law

Dear expert,
C30 to C60 contains some data.
Say
I wan to find piano and use =MATCH("*piano*",C30:C60,0) in cell D31
It gives me the anwer 20 in D31. 20 is the squence of piano.
How can I use the function and use return the the whole cell content which
is "Play Piano"? I only know where it is. How to locate where and give the
whole content in D32 please?
Thanks
Elton


Play games
Play golf
Play guitar
Play piano
Play Kite
Play Sccoer
Play cards
Play WII
Play music
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

--
Regards!
Stefi



„Elton Law†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for specific text within last non blank cell in a range 2
Find underlined text in a cell and select the line 8

Top