Compare ranging part of a string in two columns

**Jeroen79** · 11-04-2011, 06:40 AM

Hi I'm new to all of this but I'm trying to compare the last part of two strings. In column A and B there are two lists of data all build-up in the same manner 'ID-code [department] description".

example
In column A : "TEST-79 [BA] This is a use case of a function"
In column B: "TEST-1889 [TEST] This is a use case of a function"

I want the example data to be matched on the last part of the string (This is a use case of a function) but the problem is the last part can have a length of 5 to 50 characters. The last character I want to be ignored is always "]".

I already have some code but I can imagine it cant be used for the function I want, also the selection method of column A and B can be different but its ok for me as it is.

Please Login or Register  to view this content.

**snb** · 11-04-2011, 07:02 AM

Please Login or Register  to view this content.

**Andrew-R** · 11-04-2011, 07:05 AM

When you say you want the columns to be matched what are you actually trying to do? Do you want to confirm that the value in column A also appears in column B? Do you want to perform some action on the cells?

**Jeroen79** · 11-04-2011, 07:24 AM

snd when I try to run your code I get an error on this line: cl.offset(,2)=split(cl,"]")(1)=split(cl.offset(,1),"]")(1) can it be because Im using a dutch excel version (company computer).

Andrew-R, I want the description part of the cell to be matched, column A and B are not sorted and contain information that will not be matched. Then the matched cells have to be copied to column C and D so they are both at the same row. I would be wonderfull when the not matched items from column A and B are highlighted.

**snb** · 11-04-2011, 07:31 AM

It means that your data differ form your description.
You'd best post a sample workbook.

and use:

Please Login or Register  to view this content.

PS. I also use a Dutch system; VBA is only familiar with the American language.

**Jeroen79** · 11-04-2011, 08:33 AM

Here is a sample workbook.

**snb** · 11-04-2011, 09:08 AM

Workbook in return

**Jeroen79** · 11-04-2011, 09:52 AM

Its working the way I want when both values are on the same row but when they are not on the same row this won't find the match. But I think I can incorperate this in another script I found.

The matching of the cells works so thats great, thanks.