Find Values in a Column with VLOOKUPS in It

[cgmackenzie]

Hi All,

I have a column that has 1,000 rows in it. Each cell in the column has a VLOOKUP function in it. When I search in that column I get an error telling me it can't find what I'm looking for. For example if "Sales" was the result of one of the VLOOKUPS in the column and I do a Control F and enter "Sales" I get the error.

How can I search within that column without copying and pasting values over the VLOOKUP? Please help.

Thanks,

Colin

 

[DanteAmor]

Verify the following:

Look in: Values
Within: Sheet

 

[cgmackenzie]

Dante, thank you so much!

Best Regards, Colin

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.