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




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