Cannot find text data within cell containing VLOOKUP formula

Please put your code in CODE tags so that it appears like my code below. In the text editor, highlight your code, then press the # button in the toolbar.

Anyway, you're having an issue because you're expressly telling .Find to look at the formulas, not at the value the formula results in.

Fixing that should be as simple as changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks for your input. I revised my post as you suggested. I tried changing the xlFormulas to xlValues as you suggested but there was no change.

pvor

Can you post an example workbook that demonstrates the issue you're having?

Here is the code for the example I attached.

Please Login or Register  to view this content.

You need to change the xlFormulas to xlValues in the line after sheet2 select

Thanks for your help. I did find that there was another issue which prevented the original code from working. It seems that the Cells.Find function has a problem with finding text which has either an underscore or a hyphen within the text when it is not the directly entered text. I tried to find "Win_TS" indirectly, then I just changed it to "Win" and it found the text with no problem. Changing to xlValues did work to find the text as you said.

Thanks again for your valuable help!!

Glad to help. Please mark this thread as SOLVED, and any reputation (the * in the lower left of my posts) is appreciated.