Forum Discussion
Solved
Vlookup: capacity of the table array
Hello,
I would like to know the maximum dimension supported by the parameter 'table array' in a vlookup function. How many rows and columns are supported by the 'table array' parameter?
PC: Windows10;
Thanks and regards.
The only limitation could be performance if you are on Excel 2016 or earlier version. For 365 and 2019 it was improved significantly.
2 Replies
The only limitation could be performance if you are on Excel 2016 or earlier version. For 365 and 2019 it was improved significantly.
The table array may contain as many rows and columns as you need, up to the entire worksheet.
