V Look up with drop down functionality

[Excel Dumbo]

Hello Dear Excel Gurus in here,

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

Thanks
Excel Dumb

+-------------------------------------------------------------------
|Filename: VlookUp with a drop down menu.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=543
+-------------------------------------------------------------------

 

[Don Guillett]

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|

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

Provide more info

 

[Excel Dumbo]

Hi Don,

Please see attached work sheet.


Thanks
Dumb

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

 

[Spencer101]

Hi Don,

Please see attached work sheet.


Thanks
Dumbo

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

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

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

 

[Excel Dumbo]

Hi Spencer and Don,

Please see revised attached sheet below .

Bascially I would like to do a Vlook up first, pulling out YTD (year t
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 tha
will give me 2011 JAN TD, 2011 FEB YTD etc , then 2012 JAN YTD, 201
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 effor

+-------------------------------------------------------------------
|Filename: VlookUp with a drop down menu V2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=546
+-------------------------------------------------------------------

 

[Don Guillett]

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|

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

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