Hi everyone,
I'm trying to do an index/match and I've run into an issue where if the match value is greater than 255 characters I get an error. I've created the following formula:
This works on match values less than 255 characters, but not on ones with more than 255 characters.=IFERROR(INDEX(Sheet1!L:L,MATCH(LEFT($B152,200),Sheet2!$O:$O,0)),"")
Any have any ideas how to get around the 255 character limit? I've tried a few other ways I found online without success.
Thanks!
Bookmarks