Tag Archives: FIND

How to Find an Exact Match Using VBA

The Search Feature in Microsoft Excel Before digging into how to look for exact matches in VBA, I’ll give you some context with the easiest way to accomplish this goal — the search function in Excel. Microsoft Excel provides us with an excellent feature that

Excel VBA: If Cell Contains Value Then

In this article, we will look at how to automate the launching of a particular action when a cell on the worksheet contains a particular value. There’re three ways that we can do this with; InStr, Like, and Find. Example 1: INSTR Instr is a

No Thumbnail

Excel Formulas and Function, Finding Text Within Another Text, Find()

The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found. You can download the workbook related to this article here. Jump To: Syntax Example 1 Example 2 Syntax: =FIND(Text_to_Find, Text_to_Search_in, Starting_Index) Text_to_Find: The