srinidhi
Active Member
Hi Excel Experts,
I work with large data sets in excel and very frequently apply the Vlookup formula.
In the Vlookup formula there is an parameter called Col_Index_num, where we key in the result column number.
ex: Columns A:F, we key in as 6 , as need the result from F Column, this range changes from workbook to workbook.
Is there a possibility of auto generating the Col_Index_num (in the vlookup formula) based on the last column selected.
I work with large data sets in excel and very frequently apply the Vlookup formula.
In the Vlookup formula there is an parameter called Col_Index_num, where we key in the result column number.
ex: Columns A:F, we key in as 6 , as need the result from F Column, this range changes from workbook to workbook.
Is there a possibility of auto generating the Col_Index_num (in the vlookup formula) based on the last column selected.