FIELD WITH FORMULA CANNOT BE FOUND ALT-F

[meppwc]

I have fields in a column, whereas the value seen is the result of the underlying formula within that field. For example
The cell shows "C84326694", but the formula in that cell is =IFERROR(XLOOKUP(F4739,'OBIEE TABLE'!A:A,'OBIEE TABLE'!D:D),"")
If I select Alt-F and search for C84326694, the value is never found.
Is there something that I can do where as seen values in that column can be searched for?

 

[Fluff]

Change the Look-in from Formulas to values.

 

[meppwc]

Yep, that did it. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.