Find

[JPFlynn]

I cannot "Find" values in my sheet only text. What should I do?

[#2]

@JPFlynn 

I guess we speak about the numbers - texts are also values.

Perhaps for numbers you use formatted representation to find, not numbers itself. Let say you have number 1 formatted as $1.00. You'll be able to Find 1, but not $1.00