| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the problem with this formula?
=IF(ISNUMBER(MATCH("*John*",C12:C14,0)),C12&" "&C13&" "&C14,"None")
" wrote: =IF(FIND("John", C12:C14, 1), C12:C14, "None") Could anyone help me out with what the issue is with the above formula? Whenever I enter the above formula in a cell, it gives me a #VALUE error. I just want to find if there is John written in cells C12 thru C14, and if there is, I want it to type all the info from cells C12 thru C14 on another cell. All help is appreciated! Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the problem with this formula?
Thank you for all your help! I just used it and it works!
Thanks a lot Teethless mama wrote: =IF(ISNUMBER(MATCH("*John*",C12:C14,0)),C12&" "&C13&" "&C14,"None") " wrote: =IF(FIND("John", C12:C14, 1), C12:C14, "None") Could anyone help me out with what the issue is with the above formula? Whenever I enter the above formula in a cell, it gives me a #VALUE error. I just want to find if there is John written in cells C12 thru C14, and if there is, I want it to type all the info from cells C12 thru C14 on another cell. All help is appreciated! Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| formula percentage problem | New Users to Excel | |||
| problem with Array Formula | Excel Worksheet Functions | |||
Linear Mode
