<div>
I have not been able to get excel to search a formula for text if that is what you are trying to do. VBA can do it. If you just want to see where the formulas are you can press Ctrl + ~ to toggle between formulas and values.
</div>


<div>
mattclarified,<br />
<br />
I cannot reporduce the behavior. &nbsp;Can you upload a smallish sample that does exhibit that behavior, along with the work steps you are using?<br />
<br />
Patrick
</div>


<div>
What exactly are you searching for? Can you give some specific examples?
</div>


<div>
I have narrowed it down now, it seems to only happen on the one sheet. &nbsp;The reason it would not find the value when using &quot;look in: Values&quot; was because of the comma separator. &nbsp;It seems on this sheet, whenever you use the &quot;look in: Formulas&quot; option it will not find anything.<br />
The data is pretty basic, I can't upload the spreadsheet as the data is sensitive, but have included some screenshots.<br />
<br />
Thanks<br />
M@ <a href="https://filedb.experts-exchange.com/incoming/2011/08_w33/487140/screen1.jpg" target="_blank" title="screenshot1 (163 KB)"><img alt="screenshot1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/08_w33/800_487140/screen1.jpg" /></a> <a href="https://filedb.experts-exchange.com/incoming/2011/08_w33/487141/screen2.jpg" target="_blank" title="Formula's (109 KB)"><img alt="Formula's" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/08_w33/800_487141/screen2.jpg" /></a>
</div>


screen1.jpg

screen2.jpg

<div>
I think we need actual data, dummy will do.
</div>


<div>
The problem is, if I copy it, it's fine, but the spreadsheet is too big to sit there copying bits out to another spreadsheet unless it is the final option!
</div>


<div>
Like Patrick I cannot replicate this unfortunately.
</div>


<div>
Closing question as no one could help being as the problem was quite bizarre. Ended up rebuilding the sheet in another file
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an excel spreadsheet that has a column of simple functions in it, =a1-b1, =a2-b2, etc.<br />
<br />
Whenever you try to search the worksheet for values that are known to be in these fields it will not find them, regardless of whether you search by value or formula.<br />
<br />
I have tried recreating the values and the formula's, but as it is quite an extensive spreadsheet I haven't recreated the whole spreadsheet (Last resort!)<br />
<br />
If anyone has any ideas or anything to check please let me know<br />
<br />
Thanks<br />
M@
</div>
</div>


Hi,

I have an excel spreadsheet that has a column of simple functions in it, =a1-b1, =a2-b2, etc.

Whenever you try to search the worksheet for values that are known to be in these fields it will not find them, regardless of whether you search by value or formula.

I have tried recreating the values and the formula's, but as it is quite an extensive spreadsheet I haven't recreated the whole spreadsheet (Last resort!)

If anyone has any ideas or anything to check please let me know

Thanks
M@

Can't find known cell values in excel spreadsheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.