PRADEEPSWALSE
New Member
- Joined
- Nov 27, 2018
- Messages
- 28
- Office Version
- 2013
- Platform
- Windows
Hello,
I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category.
=LOOKUP(9.99999999999999E+307,SEARCH(" "&MOC&" "," "&$C2),CODE)
But it returns to #N/A.
<tbody>
</tbody>
<tbody>
</tbody>
Please help.
I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category.
=LOOKUP(9.99999999999999E+307,SEARCH(" "&MOC&" "," "&$C2),CODE)
But it returns to #N/A.
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | C01 | ||
<tbody> </tbody> | L01 | ||
<tbody> </tbody> | S01 |
<tbody>
</tbody>
Please help.