For Vlookup syntax: Vlookup $($lookup value, table range, column index, $[$range lookup$]).$ What is the column index?

This has to be sometimes specified by the column $($e$.$g$.$ F$)$ for very large datasets

This is the position of the column that contains the value you want Excel to return from the lookup table

This is the number you specify when you want Excel to lookup a value that isn't in the first column.