May 11 2021 12:15 AM
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.
May 11 2021 12:43 AM
The table array may contain as many rows and columns as you need, up to the entire worksheet.
May 11 2021 02:00 AM
SolutionThe only limitation could be performance if you are on Excel 2016 or earlier version. For 365 and 2019 it was improved significantly.
May 11 2021 02:00 AM
SolutionThe only limitation could be performance if you are on Excel 2016 or earlier version. For 365 and 2019 it was improved significantly.