Hello Dear Excel Gurus in here,

Please help me with the Vlookup formula together with a drop down functionality that will automatically update figures.

Thanks
Excel Dumbo

On Wednesday, August 15, 2012 3:49:17 AM UTC-5, Excel Dumbo wrote:
Hello Dear Excel Gurus in here,



Please help me with the Vlookup formula together with a drop down

functionality that will automatically update figures.



Thanks

Excel Dumbo





+-------------------------------------------------------------------+

|Filename: VlookUp with a drop down menu.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=543|

+-------------------------------------------------------------------+







--

Excel Dumbo

Provide more info

Hi Don,

Please see attached work sheet.


Thanks
Dumbo

Even from the attachment it's still not amazingly clear what you're trying to achieve with this.

You'll need to provide us with a little more information.

Hi Spencer and Don,

Please see revised attached sheet below .

Bascially I would like to do a Vlook up first, pulling out YTD (year to date) values and monthly values for year 2011 and 2012 respectively.

Then I will like to insert a drop down box in the specified area that will give me 2011 JAN TD, 2011 FEB YTD etc , then 2012 JAN YTD, 2012 FEB YTD etc

and monthly figures 2011 JAN, 2011 FEB etc , then 2012 JAN, 2012 FEB

I hope I am clear here

Thanks in advance for your valuable time and effort

On Wednesday, August 15, 2012 3:49:17 AM UTC-5, Excel Dumbo wrote:
Hello Dear Excel Gurus in here,



Please help me with the Vlookup formula together with a drop down

functionality that will automatically update figures.



Thanks

Excel Dumbo





+-------------------------------------------------------------------+

|Filename: VlookUp with a drop down menu.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=543|

+-------------------------------------------------------------------+







--

Excel Dumbo

Send your email to dguillett1 @gmail.com and I'll send you the file