CTRL F Not Working

[LearnExcl]

Good morning,

CTRL F does not work on the columns in which the names are resulting from formulas. For example, If I have an "Index" formula to retrieve some names under B2:B250, I cannot do a CTRL F and locate any of those names somehow.

Any help will be appreciated.

 

[Comfy]

In the Find and Replace window click Options.
Select Formulas from the "Look in" box.

 

[LearnExcl]

"Formulas" were actually preselected, and what I had to do was to actually select "Values" and it worked.

Thank you!