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!