There is no file attached but:
Growth = Application.worksheetfunction.VLookup(LookupValue, Range1, 2, False)
There is no file attached but:
Growth = Application.worksheetfunction.VLookup(LookupValue, Range1, 2, False)
I tried that earlier and i got this error, so i took out the worksheetfunction part -
Runtime error 1004
Unable to get the vlookup property of the worksheet function class
i dont have a file, its a huge model and we are trying to add in a vlookup. i can create a dummy excel to show you what i'm doing
Hi,
Check the attached file and hope this will help you:
Vlookup.xlsm
Note: Check the value of Growth Variable in Debug Mode.
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Thankyou all.
I went into my model, and typed in the years. That apparently fixed the issue.
Now i just need to make sure that when the years are pulled in from the sql server (instead of manually typing), they are pasted in so that vb vlookup can find it.
Hi,
Please mark this thread as SOLVED if you think you got your solution and click * to add reputation to all those who helped you in this issue.
Regards,
Paresh J
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks