How do you know TM is a he and not a she

I don't know for sure... it is just a "gut feeling".

and shouldn't it be Toothless Mama?

That is what my spell checker keeps trying to tell me.<g

Anyway it was discovered earlier, I probably saw it here back in 2000
something.

I use it all the time and I have for a long time, if I want to hardcode
let's say a grade setup in vlookup I just create a table first, then I put
in the grades and their values and what looks like.


=VLOOKUP(A1,F3:G8,2,0)

will look like

=VLOOKUP(A1,{0,"F";55,"D";65,"C";75,"B";85,"A+";95 ,"A+"},2,0)


after I have highlighted F3:G8 and pressed F9, that way a poster can just
copy the formula directly and just change A1
Same when I build complicated formulas where I can select parts of the
formula to find out where the problem is, that is much easier than using
the built in auditing tool. The way out is to use the escape key otherwise
it will be fixed

Yes, I use F9 for that too (it is great for looking at array results also).
For some reason, I didn't link the two uses of F9 in my mind, probably
because NOW() seems different from a "normal" function (no arguments, I
guess is why).

Rick