Hi all!

I was fortunate enough to find 50% of my problem resolved by a great solution, provided by forum guru, martindwilson, on a thread entitled "Searching if a cell contains a range of values" - Found here: http://www.excelforum.com/excel-form...ml#post3756333

I'm hoping that someone can shed some light on how I can solve the other half of my problem. In a nutshell:

I have a range of valid, unique data in an array called Affected_Systems, which can appear anywhere within a cell in either column H or column I. I need to identify in column CA, whether the unique data appears in either of the two columns (H or I); and flag it "Yes" or "No", as appropriate.

The formula that martindwilson provided in the other thread is:


=IF(ISNUMBER(LOOKUP(10^99,SEARCH(gtld,A2))),"found","not found")

I appreciate any input.

PS - Thanks, in advance, to martindwilson for the above formula... which will certainly prove useful for future endeavours.

Cheers!