Compare two columns

Solved/Closed

kumar - Apr 21, 2016 at 12:48 AM
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.

Compare two columns
Beyond compare - Download - File management
Display two columns in data validation list but return only one - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Excel compare two columns for partial matches - Guide
How to compare two Excel sheets with varying data ✓ - Excel Forum

1 response

Answer 1 / 1

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 21, 2016 at 02:31 AM

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.

kumar
Apr 21, 2016 at 05:51 AM

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.

Similar discussions

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

Extract identical cells of 2 columns (excel)

VBA Compare 2 sheets and output difference to 3rd sheet

Macro to compare 2 sheets and copy differences

Similar discussions

Subscribe To Our Newsletter!