VBA Vlookup #N/A Error

Hi,

Could you please post a workbook with dummy data so we can run it on data similar to yours? In general #NA means that its not present, but since you say that when you manually put the formula then it works then it would interesting to see the formulas action to see what is going wrong.

abousetta

Quick question... your data seems to run from Row 20000 but vlookup is only from Row 4000 and you are copying the formula down to the last used row (k). Is K more than 4000?

abousetta

Hi

K is higher than 4,000, its about 6-8000. Will this cause a problem?

Unfortunalty i am having trouble uploading a workbook, i keep getting a database error

Without seeing your data if the value you are looking in below row 4000 then you will get a #NA error. Just for fun, why don't you try changing this number to 10000 and see what happens.

Regarding the upload, if the file is too big then you can zip it, else try uploading later.

abousetta

I have had a look and the #N/A Error starts at row 4000.

Does this mean it can not autofill past row 4000??

Can i do multiple autofills??

I have managed to attach a dummy workbook!

Untested:

Maybe try replacing:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

This should span the full size of your data set.

abousetta

Thanks for posting the workbook. I replaced the number 4000 with 40000 and it worked. For example in H2:

Please Login or Register  to view this content.

and drag down.

abousetta

Hi

Slightly embrassed i didn't notice that!!

But thank very much for your help!! You have been a great help!!! I am utterly grateful!!!

THANKS!!!

I am glad I could help. I have had instances that when my code was missing a period and that was throwing the code completely off and so its all good...

Good luck.

abousetta

P.S. Thanks for marking the thread as solved