+ Reply to Thread
Results 1 to 5 of 5

Display column based on dropdown

  1. #1
    Registered User
    Join Date
    05-03-2012
    Location
    lithuania
    MS-Off Ver
    Excel 2007
    Posts
    44

    Display column based on dropdown

    Hi, I have column 1 with a dropdown field in a cell, columns to the left have dropdown field names like forumula1, forumula2,forumula3,forumula4

    Below are rows with data.

    Please see attached file to see what I mean. I tried using hlookup but it does not work.
    Attached Files Attached Files

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Display column based on dropdown

    Try this formula in D8, and fill down

    =HLOOKUP($D$7,$E$7:$H$28,ROWS(D$7:D8),0)
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,898

    Re: Display column based on dropdown

    =HLOOKUP($D$7,$E$7:$H$28,ROW(C2),FALSE)

    and copy down.


    Regards, TMS
    Last edited by TMS; 05-03-2012 at 11:38 AM. Reason: My 6000th post ;-)
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    05-03-2012
    Location
    lithuania
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Display column based on dropdown

    Quote Originally Posted by DGagnon View Post
    Try this formula in D8, and fill down

    =HLOOKUP($D$7,$E$7:$H$28,ROWS(D$7:D8),0)
    Thank you it worked fine

  5. #5
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Display column based on dropdown

    Glad to help, could you please mark as solved?

+ Reply to Thread

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