I need to match data in two sheets.
There are two queries related to it.
1) One of the columns to be matched is having same data in both the sheets but it is not exact (e.g. In sheet 1 col A data input: xyz hotel, in sheet 2 Col A data input xyz london hotel). So vlookup is not working there.
2) I have to match data based upon inputs of two columns. It would be correctly matched if and only if both data input in A & B columns in sheet 1 match with A & B column in sheet 2. (E.g. The same hotel is present in 2 different cities, hence have 2 different addresses. Therefore for correct result the hotel and the city both should match.)
Thanks in advance!
There are two queries related to it.
1) One of the columns to be matched is having same data in both the sheets but it is not exact (e.g. In sheet 1 col A data input: xyz hotel, in sheet 2 Col A data input xyz london hotel). So vlookup is not working there.
2) I have to match data based upon inputs of two columns. It would be correctly matched if and only if both data input in A & B columns in sheet 1 match with A & B column in sheet 2. (E.g. The same hotel is present in 2 different cities, hence have 2 different addresses. Therefore for correct result the hotel and the city both should match.)
Thanks in advance!