VBA - Match UDF to overcome 256 ch limitation

[cacos]

Hi all!

Can anyone point me in the right direction to writing a UDF for a MATCH capable of matching cells with over 256 characters? Never written a udf before.

Thank you!

 

[NARAYANK991]

Hi Lucas ,

Are you particular that it should be VBA ? There are formula workarounds ; see here :

http://stackoverflow.com/questions/...xcel-vlookup-function-limit-of-256-characters

Narayan

 

[Marc L]

Hi cacos,​

​

you already had a hint to break this limit in VBA in your previous thread ! … ​

(which I had no answer since my last post)​

 

[cacos]

I'll check Marc, didn't notice that one I'll go over it!

 

[cacos]

@Narayank: you're right the formula you pointed works perfectly! Now I just need to understand why. Thanks!

 

[ashleygon]

I would recommend you to use the Long Path Tool. I'm confident, it will sort out your problem.