Yes, I can. However, given the nature of the data I'm looking up, I'd prefer
an exact match over the first x characters (which x appears to max out at
255).
--
Cordell


"Anne Troy" wrote:

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