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:

=IFERROR(INDEX(Sheet1!L:L,MATCH(LEFT($B152,200),Sheet2!$O:$O,0)),"")
This works on match values less than 255 characters, but not on ones with more than 255 characters.

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!