How many VLOOKUP function parameters are optional?
Rajesh Pathak
In any function, arguments given in square brackets are optional.

In Vlookup, last argument ‘range lookup’ is optional.

Homepage
MS EXCEL TRAINING