In article .com,
"Harlan Grove" wrote:

No need to include the 4th argument to VLOOKUP when it's TRUE. What's
gained?

Clarity & specificity?

Given that the majority of users don't even know that there *is* a
fourth argument, I usually include it explicitly to make it clear that I
intended the lookup to return an approximate match.

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

This could be done with a single formula without ancillary cells.

That's a far better solution, but it could be significantly simplified...


=SUMPRODUCT(--(C6{0,300,500,1000}),(C6-{0,300,500,1000}),{0.25,-0.05,
-0.05,-0.05})

See

http://www.mcgimpsey.com/excel/variablerate.html