I'm trying to look up lookup up some lengthy text values in a table. I'm
getting #VALUE! error messages when my lookup up text value is 255
characters. This appears to be an Excel limitation.

Can anyone confirm this and offer a potential alternative?

Thanks,


Cordell