Custom function for vlookup


M

Madiya

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
 
Ad

Advertisements

D

Don Guillett

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

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.
 
S

Subrata

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

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.
 
M

Madiya

Thanks for reply.

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

Regards,
Madiya
 
M

Madiya

Don,
Thanks a ton.
I am sending my both xl files to you on mail with same subject as this post.

Regards,
Madiya
 
M

Madiya

Don,
Thanks a ton.
I am sending my xl file in mail to you with same subject as this post.

Regards,
Madiya
 
Ad

Advertisements

D

Don Guillett

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

Didn't get it. (e-mail address removed)
 
M

Madiya

Mail was sent to dguillett1 (e-mail address removed) without " and"
Now again sent to dguillett (e-mail address removed) without " now"

Hope you will get it now.

Regards,
Madiya.
 
D

Don Guillett

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

NO spaces
 
M

Madiya

Yes. sent without spaces.
Is there any other way to provide you both the files?

Regards,
Madiya
 
D

Don Guillett

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
(e-mail address removed)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top