| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find certain text in a column and return statement
I need help writing a formula that says if column AH (for example), contains the text "schedule AK", then display a statement such as "not found in contract". The cells will have about 29 characters and this text appears at the very end. I'm sure this is pretty simple for someone out there, but I've banged my head against the wall researching this. Seems that VLOOKUP and such only applies to the first column. -- TelecomAuditor ------------------------------------------------------------------------ TelecomAuditor's Profile: http://www.excelforum.com/member.php...o&userid=26525 View this thread: http://www.excelforum.com/showthread...hreadid=397943 |
|
#2
|
|||
|
|||
|
=IF(FIND("schedule AK",AH1),"not found in contract","") TelecomAuditor Wrote: I need help writing a formula that says if column AH (for example), contains the text "schedule AK", then display a statement such as "not found in contract". The cells will have about 29 characters and this text appears at the very end. I'm sure this is pretty simple for someone out there, but I've banged my head against the wall researching this. Seems that VLOOKUP and such only applies to the first column. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=397943 |
|
#3
|
|||
|
|||
|
Try this: =IF(COUNTIF(AH:AH,"*schedule AK")0,"not found in contract","") -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=397943 |
|
#4
|
|||
|
|||
|
Thank you, Cutter! It worked beautifully. -- TelecomAuditor ------------------------------------------------------------------------ TelecomAuditor's Profile: http://www.excelforum.com/member.php...o&userid=26525 View this thread: http://www.excelforum.com/showthread...hreadid=397943 |
|
#5
|
|||
|
|||
|
You're very welcome. Thanks for letting me know. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=397943 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Vlookup of an if statement return | Excel Worksheet Functions | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
Linear Mode
