What are the INDEX and MATCH functions? | It's easy to understand if you think of it as 'searching' and 'retrieving'

When it comes to functions often used for searching in Excel, there is the VLOOKUP function.And, a step further that you'll ...
Hosted on MSN

How to use the SEARCH function in Microsoft Excel

Scanning Excel spreadsheets by hand is a recipe for a headache. Whether you're flagging keywords or validating IDs, the SEARCH function is your best tool for "reading" text inside a cell. Here's how ...