Forum Discussion
sanneb1985
Jul 27, 2022Copper Contributor
vlookup column index number
when I use vlookup , and I want to fill in the column index, I no longer see numbers in the columns when I select the table array. It is difficult for me to count them, because sometimes it is column...
Martin_Weiss
Jul 27, 2022Bronze Contributor
Hi sanneb1985
yes, if you use large tables, sometimes the column numbers disappear. As a workaround, you could add a row above your table and use the COLUMN function there. This gives the absolute column number:
Please note, if your table does not start in column A, you need to add the number of additional columns to the formula. For example, if it starts in column D, you need to subtract 3 to get the correct number for your index: