Solved Search comes up with nothing

August 26, 2014 at 06:15:28
Specs: Windows 7
A good percentage of the time, when I try and search for something in the spreadsheet, it will tell you nothing found. I could be looking right at it. Why is this happening? This is a huge spreadsheet and we need to be able to search so we don't duplicate things. We are currently using Office 2007.

See More: Search comes up with nothing

Report •

August 26, 2014 at 06:48:30
✔ Best Answer
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.

Selected Range

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.

Match Case

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.

Report •

August 26, 2014 at 07:53:58
Thank you....I will look at this and see if I can figure something out!

Report •
Related Solutions

Ask Question