I have several new formulas that I've been working on. One oversimplified example being:

=LOOKUP("lion",{"bird","cat","dog","lion";"chirp","meow","bark","roar"})

It seems that the first set of LOOKUP values must be in consecutive (alphabetic) in this examle, in order to return the expected value. Is there a way to overcome this limitation?

Also, I understand that the MOD function returns the remainder after a number is divided by a divisor. But exactly how is it that MOD(NOW(),1) returns only the date?

Thanks.

ep