Match similar phrases from 2 worksheets
 

Please can some body help me. I am not the most computer literate so sorry
if my requests in quite long winded.

I have 2 seperate worksheets each contain a column which have descriptions
in a word format. The problem I have is that the descritions are only
similar and not exact. I want to perform a v-look up, but realise this isnt
possible. Please can you tell me the function which I should be using? And
a dummies guild on how to use it?
Thank you very much. Sharon.

Match similar phrases from 2 worksheets
 

Try something like this for a fuzzy match ..

In Sheet2,
With look up phrases in A2 down (to match with those in Sheet1's col A)
In B2, array-entered by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER):
=IF(TRIM($A2)="","",INDEX(Sheet1!B$2:B$100,MATCH(T RUE,ISNUMBER(SEARCH(TRIM($A2),TRIM(Sheet1!$A$2:$A$ 100))),0)))
Copy B2 across/fill down. Adapt the ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sharon" wrote:
Please can some body help me. I am not the most computer literate so sorry
if my requests in quite long winded.

I have 2 seperate worksheets each contain a column which have descriptions
in a word format. The problem I have is that the descritions are only
similar and not exact. I want to perform a v-look up, but realise this isnt
possible. Please can you tell me the function which I should be using? And
a dummies guild on how to use it?
Thank you very much. Sharon.

Match similar phrases from 2 worksheets
 

An example file to illustrate the earlier fuzzy in action:
http://www.freefilehosting.net/download/3ekd6
Fuzzy matching.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---