Match similar phrases from 2 worksheets

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

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.
 
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(TRUE,ISNUMBER(SEARCH(TRIM($A2),TRIM(Sheet1!$A$2:$A$100))),0)))
Copy B2 across/fill down. Adapt the ranges to suit.
 
Back
Top