Vlookup: capacity of the table array

[Areyan1203]

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.

[#2]

@Areyan1203 

The table array may contain as many rows and columns as you need, up to the entire worksheet.

[#3 · Accepted solution]

@Areyan1203 

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