JE McGimpsey wrote...
"Harlan Grove" wrote:
No need to include the 4th argument to VLOOKUP when it's TRUE. What's
gained?

Clarity & specificity?
....

If clarity of code were important, we wouldn't be using spreadsheets.

As for specificity, if the default value is well-defined (which it is),
there's nothing gained by including the default value of the 4th arg.
Of course, you may be using a different definition of 'specificity'.

What's gained by leaving it out, other than a few keystrokes?

Compatibility with other spreadsheets, FWLIW these days. Also, omitting
default arguments reduces file size. And, in extreme cases, it's
necessary to do so in very long formulas in order to remain under
Excel's formula length limit.

Besides, the more keystrokes there are, the more opportunities there
are for tpyos.