|Obviously it's hard for us to answer your question without actually having a copy of your spreadsheet or more detail behind what you are doing, but there are a few different things that could be going on.|
If you have more than a single cell but less than the entire range to be searched selected, Excel may find "nothing" because it is assuming you only want to search the selected range.
i.e. With data in A1:ZZ10000, and only E1 selected, Excel will search the entire range A1:ZZ10000. However, select E1:E2 and Excel will only search E1:E2.
Match Entire Cell Contents
With this option selected, Excel will search for an exact match, including leading and trailing spaces, invisible characters, etc. e.g. "find me" is not the same as " find me" if Match Entire Cell Contents is selected.
Similar to Match Entire Cell Contents, "Find Me" is not the same as "Find me" if Match Case is selected.
Data That Is Different Than It Looks
This is kind of a catch-all for the weird things that Excel might do. For example, sometimes data downloaded from a website or imported from another application may look different than it really is from an Excel internal perspective.
One way to check this is to use a cell based function to ensure that what you are searching for actually exists. Try something like this:
Let's say you are searching for my text string and you can see it in A1, but the Find feature didn't find it.
In an empty cell enter =A1="my text string" (with the quotes).
If this formula returns FALSE, then A1 doesn't really contain my text string. At that point it will take a little more investigation to determine the actual problem.
I hope that helps.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.