Ctrl-F does not find formula result....

[Emerlin]

Hi,

I have some formulas the reference a value on another sheet for a name. I cannot use ctrl-F to find the name on the formula sheet because I assume it sees the formula and no the displayed value. Any workaround to search the values?

Thanks

 

[Yongle]

{ctrl-}{F} \ Options \look in: Values

 

[Emerlin]

{ctrl-}{F} \ Options \look in: Values

Thank you for this.... I feel silly for missing it.

Thanks much.

 

[Yongle]

We have all been there! Thanks for the feedback