Compare two lists, return value against partially matchng item

Hi,

I have two tables of data and I want to do a partial match to find out if anything in Table A is in Table B, and if it is, then to add that partially matching value to a column in table B.
Table A is a list of partial values.

For example:

TableA - the values I want to check for

Watchlist
power
devel

TableB - the data I want to examine for partial matches

Items
PowerPack
predevelopment
developer
prepowered
prepower
shopping


So, with the formula I place, the output would

Table B

Items MatchedItem
PowerPack power
predevelopment devel
developer devel
prepowered power
prepower power
shopping #N/A


Can anyone help with this please ?.

Thanks!

Hi Sktneer,

Thank you for your prompt help!. In your example have amended the formula so it just returns the value that is matched:

=IF(NOT(ISERROR(SEARCH($A$2,A7))),$A$2,IF(NOT(ISERROR(SEARCH($A$3,A7))),$A$3,"#N/A"))

Ideally I would like to refer to the values in the watchlist (cells A2 and A3) as a Named List called "watchlist", but I'm having trouble amending the formula to make it use that name.

Are you able to advise please ?

Thank you so much!

Hi Sixthsense,

I've attached an example file. I hope this helps to illustrate the problem more clearly.

Thanks so much for your help.