Hi all,
Been working with some rather lengthy data, and have just finally after about 2 hours of nearly pulling my hair out realised that VLOOKUP only works with strings = to or less than 255 Characters.
Is there anyway around this problem?
I have strings, approximatley 600+ in some cases and would rather not split the strings up so i can perform a simple VLOOKUP function.
Any help is appreciated. TY all.
Been working with some rather lengthy data, and have just finally after about 2 hours of nearly pulling my hair out realised that VLOOKUP only works with strings = to or less than 255 Characters.
Is there anyway around this problem?
I have strings, approximatley 600+ in some cases and would rather not split the strings up so i can perform a simple VLOOKUP function.
Any help is appreciated. TY all.