Aug 27, 2020

Matching "Country name" with "Currency name"

Hi, I have a sheet with
- country names
- currency names, including most of the time some part of text of the 'country name'

BUT they are not in the same order, therefore and 'country' does not match with 'currency'.
I tried several lookup with "*"&cell&"*", but I don't manage to get results.

If anybody could help, it would save me 1h to reorder all manually !

Thanks in advance
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (4)
Aug 27, 2020
sheet is view only - any reason for that ?
Sep 7, 2020
Sep 8, 2020
in which column do you want the formula ?
looking at sheet - is hard tell
Sep 8, 2020
false
15034492856571716387
true
Search Help Center
true
true
true
true
true
35
false
false
Search
Clear search
Close search
Main menu