Drop-down list for col_index_num argument in VLOOKUP
It would be a great improvement if you add a drop-down list for the colindexnum argument in the VLOOKUP function as shown in the attached screenshot.
This will help us a lot to determine the desired column.
You can extend this feature by making it highlights the selected column in the table array.
NOTE: The attached screenshot is from another spreadsheet program, I love this feature, and I want you to bring it to Excel!
Kimberly Jiang commented
I agree this would be helpful. Alternatively, instead of a dropdown box, maybe it could help if Excel automatically selected the last column highlighted by the user for the col_index_num input. For example, if the user highlights A:Y, col_index_num would default to 25.
Haytham's suggestion is good too though. I use vlookups every day, and the dropdown could held make things faster.