How do you make text produced by a VLOOKUP findable?

[scottwiebe]

In my first sheet I have a VLOOKUP pulling data from a second sheet. The first sheet has such a long list of data that it's very time consuming for me to try to find the VLOOKUP result that I want. I've tried to use the find & replace window to find the text I'm looking for, but it only searches the formula text and not the result of the VLOOKUP.

 

[MARK858]

What Settings do you have set in your Find options (in particular your Look in box)?

 

[scottwiebe]

What Settings do you have set in your Find options (in particular your Look in box)?

View attachment 78390

Yep that was it! It was looking in formulas.
Thanks!

 

[MARK858]

You're welcome