Hi,
I tried to vlookup data from other worksheet but error msg as below.
Capture.PNG
Thanks for helping.
Hi,
I tried to vlookup data from other worksheet but error msg as below.
Capture.PNG
Thanks for helping.
So what's the formula you are trying to use?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hi,
I am using as below.
Attachment 681812
Paste the formula here, please.
It looks like there is a missing ' at the start of the sheet name, but the image is fuzzy.
Last edited by AliGW; 06-10-2020 at 01:55 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.
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.
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?
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks