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
Bookmarks