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?
A way to replace all the names to be the same without replacing one by one?