Reverse Partial match lookup

Excuse the nonsensical title I have a problem that I found an awfully clunky workaround to but I wondered if there was a more refined formula based solution.
I have 2 tables listing directories 1 lists all dirs the 2nd lists dirs that require an action
I need to identify the action dirs in tab 2 that appear in tab 1 AND their subdirectories. I tried an muber of vlookup index/match and countif combinations but cant get the magic formula.
I've attached a spreadsheet as an example

but to sum up
I want to look at these values

c:\stu\uhoh\nooooo
c:\stu\uhoh\nooooo\nononono

compare it to another table that contains in it's entries

c:\stu\uhoh

And return the fact that it found a partial match. Obviously the string lengths can vary and there are loads to compare.
I was able to work direct parent to child matches but any subfolders of the child (grandchildren?) I couldn't think of a neat way to iterate this


Thanks
Stuart

Hi Stueymac,

Welcome to the forum..

I couldn't find any attachment in the post. Can you check and re upload if necessary.

-

Ahh sorry, have just attached it.

There are 3 tabs

Dirs - with values to check
Probs - with values to be checked against
and
Ideal result - the Dirs data as it would be with a successful match

Many thanks
Stuart

Hi Stuart,

See if the attached file helps Let me know if this sorts out your issue.


rev lookup_sort.xlsx



--------------------------------------------------------------------------------------------
If my reply helped, Please add reputation (click on the star below the post)
If the reply solves your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)

In dirs sheet:

B2: =IFERROR(LOOKUP(1E+99,SEARCH(probs!A$2:A$3,A2),probs!B$2:B$3),"")

copy down

Teethless mama,

Can you explain the formula. It works good.

-elayaz

Thanks for the solutions everyone. I was really stuck in a mental rut, with that
Much appreciated
Stu