"T. Valko" wrote in message
...
"Rick Rothstein (MVP - VB)" wrote in
message ...
You're welcome, Bob - 1E100 is a bit easier to type than
9.99999999999999E+307 (Excel's largest number), and is usually large
enough in most situations.

By that reasoning (easier to type, usually large enough), wouldn't it be
just as easy to type 1E300 and get nearer to the max? For that matter,
wouldn't 1E307 be just as easy also?

Rick
**********
=LOOKUP(10^10,B1:E1)

And it'd be even more efficient (recalc and storage) if you replaced the
unnecessary expression with a numeric constant.

=LOOKUP(1E10,B1:E1)
**********
See Pete, no matter what you do someone is not satisfied! <VBG (I've been
guilty of this myself but I'm trying to just let it go)

So, not only do we have to make it past Harlan, now we have to make it
past Rick! <VVVBG

LOL... 3 V's, that's like an ear-to-ear grin.

Hey, all I did was to ask a simple question (if you were going to type 100,
why not 300 at a minimum?).

Rick