Search not Returning Any Result Although Search Term Exists

[Paisquy]

Hello all,

from time to time, when searching for a cell value (text string or number) Excel's search function does not return anything although this cell value exists. It is really strange to me that Excel does not find it and I am wondering what I need to set it up differently. The option to search through the entire worksheet is already activated, although the value I am looking for (invoice numbers or amounts) reside in the sheet currently open. I switched from Search in Rows to Search in Columns which improved the result a little, but still Excel often cannot find what I am looking for. Besides, I do not know the difference between looking for something via rows and columns.

I am more than happy to hear about ideas and suggestion what I have to do differently

 

[Yongle]

Welcome to the forum

Let's try something simple and take it from there

1. Copy the attached values into a new worksheet

Excel 2016 (Windows) 32 bit

	A​	B​
1​	Invoice	Amount
2​	A_001	20.00​
3​	A_002	127.00​
4​	A_003	1,093.44​
5​	A_004	405.00​
6​	A_005	187.00​
7​	A_006	102.00​
8​	A_007	432.00​
9​	A_008	48.00​
10​	A_009	121.00​
11​	A_010	81.00​
12​	A_011	138.00​
13​	A_012	40.00​
14​	A_013	281.00​
15​	A_014	70.00​

Sheet: Sheet2

2. Click on Search icon
enter 1 (ie the number ONE) into the "Find What" box
click on Find All
there are lots of values to find

(If nothing is found, click on Options button in the search box and tell us what each option is set to)

3. Hopefully lots of items were found
now enter 1093.44 and click Find All - should find B4