Compare two columns [Solved/Closed]

- - Latest reply:  kumar - Apr 21, 2016 at 05:51 AM
Hello,

In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column having text of asdf12345 and 2nd column having text of asdf1458. u see in this example, first 5 characters are matching so formula has to compare and return first five value in third columns.

Please anyone help me to sortout this issue. and I tried Vlookup its not sutable for this case.



See more 

1 reply

Best answer
Posts
2401
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
July 16, 2018
1
Thank you
Hi Kumar,

A VLOOKUP () Can help you in this situation. Try using it like this:

=VLOOKUP(A1,A1:B1,2,1)

Notice 1 at the end of the Function. This is for Approximate Match. If you make it 0, it will be Exact Match. In your case we want Approximate Match and not Exact Match.

Try this and do write back to us if this was useful.

Thank you, Zohaib R 1

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2635 users this month

Hi Zohaib,

Thanks for your reply.

Even, I Tried in the Vlookup by putting "1" at the end. its not working.

But somehow, I found the solution.

Solution is, =VLOOKUP(A1&"*",A1:B1,2,1)

we have add this &"*" after selecting the first cell.