To Fix Value Errors
How To Use The Excel Search Function? To ignore the start number and hit Ctrl Enter, as we can see with this formula there's a lot of value errors that have come up. To talk about errors shortly but it just means that if the function can't find what it's looking for it returns. This value error now .So, that we can make this function dynamic to change the a to a cell reference which is going to be C19.
The fine text parameter F4 to make that absolute control enter. 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 to the a we'll see that, restores the output of the formula. We can also use numbers in the parameter.