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...
sivakumarrj
Jul 27, 2022Brass Contributor
sanneb1985 Vlookup may create performance issue when there is selection of more columns in huge database, so better use INDEX MATCH formula.
https://www.mrexcel.com/excel-tips/excel-vlookup-index-match/
sanneb1985
Jul 27, 2022Copper Contributor
i'll dive into that and will read the tips, thank you