LOOKUP problem

  • Thread starter Thread starter jlawton
  • Start date Start date
J

jlawton

Why does the following function evaluate to zero?

LOOKUP("LATE",{"LATE";"MEGA";"STILL";"";"";"";"";""},{"Y";"N";"N";0;0;0;0;0})

It should find a match with the first item, "LATE", and evaluate to
"Y". What can I do to make this work?

Thanks for any help.

Jeff
 
This works for me:

=LOOKUP("LATE",{"LATE";"MEGA";"STILL";"";"";""},{"Y";"N";"N";0;0;0;0;0})

I don't know why the lookup vector array constant is restricted to 6
arguments.
You would think at least 7 would be a good number for XL (nested functions -
and all that).

Let's see if someone wiser then me can comment!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Why does the following function evaluate to zero?

LOOKUP("LATE",{"LATE";"MEGA";"STILL";"";"";"";"";""},{"Y";"N";"N";0;0;0;0;0}
)

It should find a match with the first item, "LATE", and evaluate to
"Y". What can I do to make this work?

Thanks for any help.

Jeff
 
Back
Top