isnumber(Search - Help please!!!

I am looking for a formula that will search a cell for a number in a string of numbers and return with either a "yes" its there or a "no" its not. I am currently using the following formula however it gets confused when you go above 10 as it thinks "11" can also be a "1" and "111" can be a "1","11" & "111".

Current Formula:

=IF(ISNUMBER(SEARCH(A28,$E$4)), "Yes", "No")

Hello and welcome to the forum.

I think that an appropriate answer is going to depend on how the data looks.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Thanks for the advice, I have attached a file. Basically i need to be able to enter different house numbers into the cells below "plots Included".
Then i want my little table below to count how many different numbers are in the cells. so for cell E4 - cells b8 to b13 is searching for the numbers and reporting either "yes" or "No",
i am then using a simple formula below to count how many are yes. So that works,

However for e5 the cells c8 to c13 are counting the same however they recognise the 1 and the 6 as individuals and if i continued down they would then pick up 16 and so on,

Thanks

Try these:

B8 =IF(ISNUMBER(SEARCH(","&A8&",",","&$E$4&",")), "Yes", "No")

C8 =IF(ISNUMBER(SEARCH(","&A8&",",","&$E$5&",")), "Yes", "No")

Thanks 63falcondude - This gets rid of the problem i had however has created a new one. it currently works as long as all numbers are separated with a "," like in the below example:
1,2,3,4,5,11

However does not recognise if there is a space somewhere in the string like below:
1,2,3,4,5, 11

Is it possible to get it to recognise in both ways? As for this spreadsheet people may enter numbers in a string with or without spaces but always seperated with commas.

Hope you can help with this

Sure, you can use these:

B8 =IF(ISNUMBER(SEARCH(","&A8&",",","&SUBSTITUTE($E$4," ","")&",")), "Yes", "No")

C8 =IF(ISNUMBER(SEARCH(","&A8&",",","&SUBSTITUTE($E$5," ","")&",")), "Yes", "No")

Awesome! that has worked. thanks so much.

Just one more small problem, For some reason if i try to increase the amount of numbers i use it stops working. For example:

I have increased the amount of numbers i want it to recognise to 300, Which it does find unless i ask it to find something like "1,222" - It will not find either of the numbers then. However "1,2,222" it recognises all 3??

If you can fix that i will be for ever in your debt

The problem is that it sees 1,222 as one thousand two hundred and twenty two.

To combat this, you can format cells E4 and E5 as Text.