Help with =IF(ISNUMBER(SEARCH

Hi,
My problem is that the function I am using does not seem to be precise enough. I'm asking it to search a box full of numbers and return an 'x' if it finds a number which matches the number in cell at the top of column, an 'o' if not. However, it's not entirely accurate. For example, if it's supposed to search for 1.1 and it finds 1.15, it still returns an 'x'.
Here is the function: =IF(ISNUMBER(SEARCH(C$1,Sheet1!$C3)),"X","O")

This is the sheet with cells returning x's and o's
x and o.JPG

These are the boxes full of numbers through which the function is searching
search box.JPG

Any help would be greatly appreciated.

Thanks.

As you have a comma following each of those numbers, try it like this:

=IF(ISNUMBER(SEARCH(C$1&",",Sheet1!$C3&",")),"X","O")

Hope this helps.

Pete

Or try this...
=IF(ISNUMBER(MATCH(C$1,Sheet1!$C3,0)),"X","O")

Originally Posted by Phuocam

Or try this...
=IF(ISNUMBER(MATCH(C$1,Sheet1!$C3,0)),"X","O")

No, there isn't an exact match.

Pete

Adding commas worked. What an easy fix. I wouldn't have even thought of that. Thanks!