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!
Bookmarks