Hi,
I want to compare two columns in excel and am using VLOOKUP for the same.
The criteria for search is:
Suppose column A and column B are to be compared.Column C is the resultant column.
1) I need to restrict my search till 4 characters in column B, as there are entries in the column A with only last few characters being different.
For ex:
Column A Column B
-------- --------
Confuse Confuse
Confusion Tradition
The syntax I am using is:
In column C (resultant column)
=VLOOKUP(LEFT(A2,5)&"*",B:B,1,FALSE) and then drag this for the entire column entry.
(But issue with this is that post comparing with column B and it displays what's there in column B as below:
Column A Column B Column C
-------- -------- --------
Confuse Confuse Confuse
Confusion Tradition Confuse
2) I want the comparision result to be picked from column A, so that I can get all kinds of similar entries from column A into the resultant column.
For ex:
Column A Column B Column C
-------- -------- --------
Confuse Confuse Confuse
Confusion Tradition Confusion
Could someone please help me in getting the above output??
Thanx in Advance
Regards,
Aakriti
I want to compare two columns in excel and am using VLOOKUP for the same.
The criteria for search is:
Suppose column A and column B are to be compared.Column C is the resultant column.
1) I need to restrict my search till 4 characters in column B, as there are entries in the column A with only last few characters being different.
For ex:
Column A Column B
-------- --------
Confuse Confuse
Confusion Tradition
The syntax I am using is:
In column C (resultant column)
=VLOOKUP(LEFT(A2,5)&"*",B:B,1,FALSE) and then drag this for the entire column entry.
(But issue with this is that post comparing with column B and it displays what's there in column B as below:
Column A Column B Column C
-------- -------- --------
Confuse Confuse Confuse
Confusion Tradition Confuse
2) I want the comparision result to be picked from column A, so that I can get all kinds of similar entries from column A into the resultant column.
For ex:
Column A Column B Column C
-------- -------- --------
Confuse Confuse Confuse
Confusion Tradition Confusion
Could someone please help me in getting the above output??
Thanx in Advance
Regards,
Aakriti