Can't confirm the limitation, but can you lookup left(a1,10) or something
that returns and looks up only the first X values?
************
Anne Troy
www.OfficeArticles.com
"Cordell" wrote in message
...
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