I would like to do "Partitional VlookUp".
What I mean, for example in one table I have following items:
ON
NATIONAL
MICRO
in other table I have:
ON SEMICONDUCTOR
NATIONAL SEMICONDUCTOR
MICRO SEMICONDUCTOR
I would like to link between same items (to look part of the word).