The File I used to make these videos is available for download:
These videos are designed specifically to teach how to create a function that returns TRUE if a string of text you wish to search for is contained within a longer, more complex piece of text in Microsoft Excel. This can be used along-side an IF statement that allows for conditional behavior and text manipulation for a wide variety of purposes. This is done by creating a nested formula using Excel’s ISNUMBER and SEARCH functions. Two versions are available, on in-depth and one quick tip but both are designed to explain how each of these functions works and how they work together to accomplish your “needle in a haystack” text search.