I am using Vlookup to link pais of value, where I am trying to link values not by exact values, but based on partual value. Similar to what is described here: exceljet.net/formula/partial-match-with-vlookup, but in opposite way.
In this example "Aya" is linked with the value "Ayala", while in my case I would like to achieve that my vlookup will recognize "Ayala" and connect it with "Aya" in my reference table.
How to achieve that?
I though I should replace:
withPlease Login or Register to view this content.
, but it is not workingPlease Login or Register to view this content.
Bookmarks