![]() Way to overcome Excel Vlookup function limit of 256 characters, For rows greater that 256 characters, it returns a '#N/A'. ![]() ![]() PS Can't help but wonder why the original VLOOKUP written by professionals is implemented in this particular case more poorly than this 10-lined func? Function betterSearch(searchCell, A As Range, B As Range) It doesn't care about the length of your cells' values. I had the same problem and I've wrote this custom primitive vlookup.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |