In This Session we are quite simply looking for a character or a string of characters within some text. We then return the position of that character or that string of characters in cell h4. Enter the formula equals to search and find text. You can look for the text in B4.

To Fix Value Errors

To ignore the start number, hit Ctrl Enter. As we can see with this search formula in Excel, there are a lot of value errors that have come up. To talk about errors shortly, it just means that if the function can’t find what it’s looking for, it returns. We can make this function dynamic to change the cell reference, which is going to be c19.

As we have not got anything in the cell C19. It’s treating that as a wild card. It’s returning one for every cell but if we change this back we’ll see that restores the output of the search formula in Excel. We can also use numbers in the parameter.