I got the same error result using xl2003.

If there's no way to use a short key value, maybe you could split that long
value into multiple cells in the same row (each part not exceeding 255
characters).

But then you'd have to split that lookup value the same way, too.

If that's a possibility, then this kind of formula may work for you:

=index(othersheet!$c$1:$c$100,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))
(one cell)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Cordell wrote:

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

--

Dave Peterson