Dear forum members,
I am looking for a mapping tool.
The macro needs to assign (or map) list B items to list A items by placing the relevant number of the list B item in C column and adding a complementary description (Exact or Partial) in D column. Examples and results spreadsheet is attached.
• Text strings within the same cell are separated by the + sign with no spaces between the text and the + sign, from both sides of the + sign.
• Text string may contain more than one word.
• No sensitivity to capital letters i.e. Cars and cars are the same from my point of view.
• The order of text strings within the same cell is not important. Recognizing the combination of the text strings is important.
• In case full combination of text strings were recognized the word "Exact" should be added in the D column.
• In case all the first words combination was found but not the entire text strings combination was found - the word "partial" should be added to column D. See examples.
• In case nor partial neither partial combination was found the word "Not found" should be added to column C.
• In case exact and partial combinations were found for the same item of list A only the exact combination will be indicated (see example of item 8 of list A).
• List A and B may have different length. Length may be changed from case to case.
Thanks so much,
Yoram
Bookmarks