Index/Match greater than 255 characters using LEFT function

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:

Please Login or Register  to view this content.

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!

,

Here is solution, but in Turkish Language.

http://www.excelgurusu.com/vlookup-s...-countifs-256/


.

Try it like this:

=IFERROR(INDEX(Sheet1!L:L,MATCH(LEFT($B152,200)&"*",Sheet2!$O:$O,0)),"")

Hope this helps.

Pete