Results 1 to 2 of 2

Complex VLookup and then adding drop down functionality

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-26-2012
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    274

    Complex VLookup and then adding drop down functionality

    Hello,
    Please see 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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1