Matching two lists with values that are similar, but not identical

[alon]

Hello all,
I have a problem and I hope you can help. I'll try to explain it as clearly as possible.

I have two columns with textual values in them. The values are similar, but not 1:1 identical.
For instance, what is called in one column
"I'm cell number 1"
might be called in the other column
"Im cell nu 1"

The similar values are not in the same rows.
The ideal output I wish to have is two columns with the similar names one next to another.
No idea how to achieve this non-manually (two very long lists)
I tried vlookup with True for matching, but it didn't work well.

Here's a file with a small subsection of the lists:

https://dl.dropbox.com/u/7112203/question-lists.xlsx

I hope you can help.
Thank you in advance

 

[Robert Mika]

Hello all,
I have a problem and I hope you can help. I'll try to explain it as clearly as possible.

I have two columns with textual values in them. The values are similar, but not 1:1 identical.
For instance, what is called in one column
"I'm cell number 1"
might be called in the other column
"Im cell nu 1"

The similar values are not in the same rows.
The ideal output I wish to have is two columns with the similar names one next to another.
No idea how to achieve this non-manually (two very long lists)
I tried vlookup with True for matching, but it didn't work well.

Here's a file with a small subsection of the lists:

https://dl.dropbox.com/u/7112203/question-lists.xlsx

I hope you can help.
Thank you in advance

What f the second list have
A Glass of Water and
A Glass

Which word would you want to return/match?

You can try to look at this thread:

http://www.mrexcel.com/forum/excel-...-matching-new-version-plus-explanation-8.html

 

[alon]

Thanks for the message.
I'm exploring that thread (and the link it refers to)

Why I'm interested in is sorting and matching. To have both versions one by the other, separate columns same row.

What f the second list have
A Glass of Water and
A Glass

Which word would you want to return/match?

You can try to look at this thread:

http://www.mrexcel.com/forum/excel-...-matching-new-version-plus-explanation-8.html