The lookup_vector MUST be sorted in ascending order.

Is Name* the REAL value or is that just a made-up example?

Also note that the values in your result_vector are TEXT values, not numeric
values. Enclosing numbers in " " makes them TEXT.

If those are the real names then:

=RIGHT(A2,1)

will do the same thing. Is Name2r a typo?

Biff

"MsBeverlee" wrote in message
...
I having a problem with the LOOKUP function. I follow the example on the
Excel Help, but it doesn't seem to be generating the correct result. Here
is
the formula I'm using:

=LOOKUP(A2,{"Name1","Name2r","Name3","Name4","Name 5","Name6","Name7","Name8"},{"1","2
","3","4","5","6","7","8"}).

Cell A2 does equal "Name1", but the formual is yielding the result "4",
instead of "1". According the the Excel Help, the formula should

"Looks up the value in A2 ("Name1") in the first row of the array, finds
the
largest value that is less than or equal to it, and then returns the value
in
the last row of the array that's in the same column."

This doesn't seem to be happening and my formula keeps returning a value
that is NOT is the same column.

Any suggestions? Am I inputting the formula incorrectly?

Thanks for your help!