I have 3 sheets in Excel. In the 1st one there is a column with hotel names
and another one with ID
. I want to get that ID
from the ID
column on the 2nd sheet where I have the names as well.
The problem is that sometime the name on the 1st sheet is Mirsini
and on the 2nd sheet is Mirsini Hotel
. So the result of a VLOOKUP
if set to false is #NA
or in true it returns a wrong number.
Is there a way to exclude keywords somehow?
OR
A way to replace all the names to be the same without replacing one by one?