Thanks for the reply. I managed to figure it out! Thought I'd post it
in case it might help someone else. Or, if anyone sees a way I can
clean it up a bit if it's redundant...

=INDEX(codes!$A$2:$B$4001,MATCH($M3491,codes!$A$2: $A$4001,0),2)




Biff wrote:
"bman342" wrote in message
...
Biff:

Might you need a "value" function for the "left" function, to derive the
numeric value to accurately compare?

Also, I've spent some time reading through these messages. I notice on a
some of your posts you put "--" [such as "(--LEFT(M2,7)..."]. What does
"--"
mean? Thanks.

That's what the double unary does, it converts a TEXT number into a NUMERIC
number.

Since the LEFT function returns a TEXT value the "--" comverts the result to
a NUMERIC number. You can do the same thing using any of these methods:

VALUE(LEFT(M2,7))
1*LEFT(M2,7)
0+LEFT(M2,7)
--LEFT(M2,7)

I just use the double unary as personal preference.

Biff