Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Custom function for vlookup

32 views
Skip to first unread message

Madiya

unread,
May 12, 2012, 6:13:05 AM5/12/12
to
I have a master file which I regularly use to get data by way of vlookup.
Each time I use vlookup, i have to open the master file and type the formula.

Is there a short way to get the data without typing full vlookup formula?

I thought one option as custom function.
Is there any other option?
I am doing it may be 80-90times a day, so a shortcut will save lots of time.

Pl guide.

Regards,
Madiya

Subrata

unread,
May 12, 2012, 9:42:21 AM5/12/12
to
Write a custom function in a module in the personal.xlsb file. You can access it from the VB editor. Your function should access your master workbook. For that you will have to store that in a particular location. Next time you open some file then this custom function will be available to you.

Madiya

unread,
May 12, 2012, 9:55:36 AM5/12/12
to
Thanks for reply.

Is there any other way by way of formulas or using names etc?

Regards,
Madiya

Don Guillett

unread,
May 12, 2012, 8:30:46 AM5/12/12
to
A bit more detail would be helpful. If the formlula is in the master file and is looking up in a slave file then wouldn't the master file be open??? You may send your file with a slave to dguillett1 @gmail.com if desired.

Madiya

unread,
May 14, 2012, 10:42:25 AM5/14/12
to
Don,
Thanks a ton.
I am sending my both xl files to you on mail with same subject as this post.

Regards,
Madiya

Madiya

unread,
May 14, 2012, 10:50:57 AM5/14/12
to
Don,
Thanks a ton.
I am sending my xl file in mail to you with same subject as this post.

Regards,
Madiya

Don Guillett

unread,
May 15, 2012, 11:38:27 AM5/15/12
to
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
Didn't get it. dgui...@gmail.com

Madiya

unread,
May 16, 2012, 7:44:11 AM5/16/12
to
Mail was sent to dguillett1 a...@gmail.com without " and"
Now again sent to dguillett n...@gmail.com without " now"

Hope you will get it now.

Regards,
Madiya.

Don Guillett

unread,
May 17, 2012, 6:32:16 PM5/17/12
to
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
NO spaces

Madiya

unread,
May 18, 2012, 5:51:10 AM5/18/12
to
Yes. sent without spaces.
Is there any other way to provide you both the files?

Regards,
Madiya

Don Guillett

unread,
May 20, 2012, 8:28:04 AM5/20/12
to
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
This is my email address
dguil...@gmail.com




On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:

Madiya

unread,
May 24, 2012, 6:45:36 AM5/24/12
to
I have sent the mail again.
Pl help.
Regards,
Madiya

On Sunday, May 20, 2012 5:58:04 PM UTC+5:30, Don Guillett wrote:
> On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
> > I have a master file which I regularly use to get data by way of vlookup.
> > Each time I use vlookup, i have to open the master file and type the formula.
> >
> > Is there a short way to get the data without typing full vlookup formula?
> >
> > I thought one option as custom function.
> > Is there any other option?
> > I am doing it may be 80-90times a day, so a shortcut will save lots of time.
> >
> > Pl guide.
> >
> > Regards,
> > Madiya
>
> This is my email address
> dguillett1 @gmail.com
0 new messages