Cordell,

You could try matching against the first 255 characters, like so

=MATCH(LEFT(A1,255),LEFT(N1:N2,255),0)

which is an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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