101k views
2 votes
When using vlookup, the _____argument is optional?

User RamC
by
7.9k points

1 Answer

4 votes
To VLOOKUP function in excel has 4 arguments:
1. the lookup_value -the value you are looking for
2. table_array - The range of cells that make up the table
3.column_index-he number of the column from which to retrieve a result (column_index)
4. range_lookup - The match mode - this argument is optional
When using vlookup, the range_lookup argument is optional
User Krishnadas PC
by
8.4k points