SOLVED

Vlookup: capacity of the table array

%3CLINGO-SUB%20id%3D%22lingo-sub-2343502%22%20slang%3D%22en-US%22%3EVlookup%3A%20capacity%20of%20the%20table%20array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2343502%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20the%20maximum%20dimension%20supported%20by%20the%20parameter%20'table%20array'%20in%20a%20vlookup%20function.%20How%20many%20rows%20and%20columns%20are%20supported%20by%20the%20'table%20array'%20parameter%3F%3C%2FP%3E%3CP%3EPC%3A%20Windows10%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20regards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2343502%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2343613%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%3A%20capacity%20of%20the%20table%20array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2343613%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1050505%22%20target%3D%22_blank%22%3E%40Areyan1203%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20table%20array%20may%20contain%20as%20many%20rows%20and%20columns%20as%20you%20need%2C%20up%20to%20the%20entire%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2343826%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%3A%20capacity%20of%20the%20table%20array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2343826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1050505%22%20target%3D%22_blank%22%3E%40Areyan1203%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20only%20limitation%20could%20be%20performance%20if%20you%20are%20on%20Excel%202016%20or%20earlier%20version.%20For%20365%20and%202019%20it%20was%20improved%20significantly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies

@Areyan1203 

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

best response confirmed by Areyan1203 (Occasional Visitor)
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.