SEARCH Function

You are tasked with auditing legal expenses for a company.

You suspect that legal expenses may be miscoded in other accounts so you decided to look through the utilities expense account.

What's the best way to do this? Building a search box of course! Since you don't care about capitalization, you will use the SEARCH function instead of the FIND function. The SEARCH function uses the following format:

SEARCH(search_for, text_to_search)

Let's hold off on conditional formatting for now and use the regular functions in cells first.