Find/search formula within cell

I have stumbled across a small issue which I can’t seem to overcome. In column A, I have a list of amounts for example
Column A
234.34
2286.59
100.00
1286.48

In my table array, the data is not consistent. For example, in one cell, I may have ‘’June 2006 opening balance 1286.48”

My objective is to identify if 1286.48 exists within the table array. So if I use the ctrl-f find function and enter 1286.48, it will show me that it is present, however I cannot seem to create a formula which will tell me if it exists or not.
By: Tom

Leave a Reply

Your email address will not be published. Required fields are marked *