To improve your Excel formula work, you can use a database-like structure by filling a bunch of related information in separate columns. To search for text in a specific column, you can use the SEARCH or FIND function in Excel. Here's an example of how to use these functions:
=SEARCH("search_text", A1)
In the above example, replace "search_text" with the text you want to search for, and A1 with the cell containing the text you want to search in.
If the text is not found, the function will return an error. To handle this, you can use the IFERROR function:
=IFERROR(SEARCH("search_text", A1), "Not Found")
In this example, if the text is not found, the cell will display "Not Found" instead of an error message.
For more complex search requirements, you can use the IF function in combination with the SEARCH or FIND function:
=IF(SEARCH("search_text", A1) > 0, "Found", "Not Found")
In this example, if the text is found, the cell will display "Found", and if it's not found, the cell will display "Not Found".
For more information, you can refer to the following resources:
<ul>
<li>Excel SEARCH Function: <a href="https://support.microsoft.com/en-us/office/search-function-859358d5-6c75-440c-881c-7210413f643e">https://support.microsoft.com/en-us/office/search-function-859358d5-6c75-440c-881c-7210413f643e</a></li>
<li>Excel FIND Function: <a href="https://support.microsoft.com/en-us/office/find-function-44c3598f-274c-481c-b90b-14607a43820d">https://support.microsoft.com/en-us/office/find-function-44c3598f-274c-481c-b90b-14607a43820d</a></li>
<li>Excel IFERROR Function: <a href="https://support.microsoft.com/en-us/office/iferror-function-7c620e4b-4f9a-458c-862a-7d324f16904d">https://support.microsoft.com/en-us/office/iferror-function-7c620e4b-4f9a-458c-862a-7d324f16904d</a></li>
<li>Excel IF Function: <a href="https://support.microsoft.com/en-us/office/if-function-59723905-1a8a-4416-b03a-0406a3580367">https://support.microsoft.com/en-us/office/if-function-59723905-1a8a-4416-b03a-0406a3580367</a></li>
</ul>