Forum Discussion

Areyan1203's avatar
Areyan1203
Copper Contributor
May 11, 2021
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: Windows...
  • SergeiBaklan's avatar
    May 11, 2021

    Areyan1203 

    The only limitation could be performance if you are on Excel 2016 or earlier version. For 365 and 2019 it was improved significantly.

Resources