ExcelBanter - V Look up with drop down functionality

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - V Look up with drop down functionality (https://www.excelbanter.com/excel-discussion-misc-queries/446849-v-look-up-drop-down-functionality.html)

Excel Dumbo

V Look up with drop down functionality

1 Attachment(s)

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

Don Guillett[_2_]

V Look up with drop down functionality

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

Excel Dumbo

Hi Don,

Please see attached work sheet.

Thanks
Dumbo

Spencer101

Quote:

Originally Posted by Excel Dumbo (Post 1604666)

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.

Excel Dumbo

1 Attachment(s)

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

Don Guillett[_2_]

V Look up with drop down functionality

All times are GMT +1. The time now is 12:46 AM.