Match (1 Viewer)

[Andy Teal]

Match

 

[Gasman]

Is it always just two columns?

 

[CJ_London]

In a macro, use the split function to separate out the elements from both cells then loop through both sets to compare for equality

I won’t bother with the code since the question example is incomplete- what if there is more than one match? Or a partial match e.g. just 05

 

[Andy Teal]

For now, just two columns will work for me. But if you can make it dynamic, it would be great.
Thanks a lot.

 

[Gasman]

For now, just two columns will work for me. But if you can make it dynamic, it would be great.
Thanks a lot.

I am not making anything. That is your job.

I was going to suggest the same logic CJ_London has proposed.
If you want more columns you would have to have more loops, as comparing column 1 and 2 might not match and also 1 and 3 not match , but 2 and 3 might match.?