VLOOKUP Worksheet limit?

[SteveWebb]

Hi and thank you in advance for looking at my problem,

Is there a limit to the number of worksheets the VLookup function can access?

I have 'Data Table', A1 - AA6000
Headings include Ref number - Date/Time - Address etc (These contain some personal data so have not been able to post an example).

Worksheets range from LI 1 through to LI 23 all with selected headings taken from the DataTable.
The Vlookup function will look for the LI match:-
Using =IF(ISNA(VLOOKUP(A2,'LI 1'!A1:J3,16,FALSE)),VLOOKUP(A2,'LI 2'!A1:K40,16,FALSE),VLOOKUP(A2,'LI 3'!A1:P196,16,FALSE)) with CSE.
Column 16 contains the data for comparison, I get to LI 4 and get an error message.

Any help much appreciated

Kind Regards
Steve

 

[SteveWebb]

Hi Glenn,
Have just realised I am in 'compatibility mode' !! is this the reason for the limit, as workbook is from an Excel 2003 based model!!!

Thanks for your help
Steve

 

[GlennUK]

Hi Glenn,
Have just realised I am in 'compatibility mode' !! is this the reason for the limit, as workbook is from an Excel 2003 based model!!!

Thanks for your help
Steve

Yes, that's the reason. Save your workbook to the latest Excel version and try again.