Worksheet Size Over for Vlookup

**garyfjh** · 06-10-2020, 01:29 AM

Hi,

I tried to vlookup data from other worksheet but error msg as below.

Capture.PNG

Thanks for helping.

**AliGW** · 06-10-2020, 01:42 AM

So what's the formula you are trying to use?

**garyfjh** · 06-10-2020, 01:47 AM

hi,

I am using as below.

Attachment 681812

**AliGW** · 06-10-2020, 01:53 AM

Paste the formula here, please.

It looks like there is a missing ' at the start of the sheet name, but the image is fuzzy.

**garyfjh** · 06-10-2020, 02:13 AM

=VLOOKUP(N10,'[ASL 13-MAY-2020 Meerkat ASL, MOQ and Price Break - program.xlsx]Meerkat ASL, MOQ and Price Br'!$A:$Q,17,0)

Thanks.

**AliGW** · 06-10-2020, 04:28 AM

That's not what is showing in the screenshot for range.

There are instructions at the top of the page explaining how to attach your sample workbook.

**bebo021999** · 06-10-2020, 04:42 AM

Are you staying in a .xls and trying to vlookup to a .xlsx file which is closing?
Try to open the .xlsx file to see if it happened again?

Re: Worksheet Size Over for Vlookup