| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for a text in a cell and give the outcome later
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search for a text in a cell and give the outcome later
=INDEX(C30:C60,D31)
-- Regards! Stefi €˛Elton Law€¯ ezt Ć*rta: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search for a text in a cell and give the outcome later
Thanks for help ...
"Stefi" wrote: =INDEX(C30:C60,D31) -- Regards! Stefi €˛Elton Law€¯ ezt Ć*rta: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search for a text in a cell and give the outcome later
You are welcome! Thanks for the feedback!
Stefi -- Regards! Stefi €˛Elton Law€¯ ezt Ć*rta: Thanks for help ... "Stefi" wrote: =INDEX(C30:C60,D31) -- Regards! Stefi €˛Elton Law€¯ ezt Ć*rta: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| varying a cell and seeing the outcome | Excel Worksheet Functions | |||
| Search and match two colums give third column result | Excel Discussion (Misc queries) | |||
| search a string as substring and give adjacent values | Excel Worksheet Functions | |||
| Locking cell depending on outcome of formulae | Excel Discussion (Misc queries) | |||
| How can I give text a numerical value in adjacent cell? | Excel Worksheet Functions | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
