Search a range for any identical string in another range

**Geoff.** · 12-31-2014, 02:03 PM

Hi there,

I have a macro that I am using to find if a certain string ("ID1") is found in a range. I posted the code below.

I've had to make some changes to my workbook and I now, instead of looking for a single string, I have to find if any strings in a certain range (sheet("Template2"), column "AH") is found in the other range.

Can anyone suggest how I can change my code below to do that?

Please Login or Register  to view this content.

Thanks,

Goeff

**Geoff.** · 12-31-2014, 02:05 PM

I think I can manage to loop this search for each value in the AH column range but that seems inefficient. Or this the way to do it?

**Geoff.** · 12-31-2014, 02:34 PM

In case more information could be helpful, I am looking to see any of the following (in column AH - can be up to 14 strings):

Temp ID
41946_Office
41953_Office
41960_Office
41967_Office

is found in column "P" of sheet "ref."

These strings are the result of a concatenate formula.

Thanks!