+ Reply to Thread
Results 1 to 3 of 3

Cell to display price when linked to drop down list

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Cell to display price when linked to drop down list

    Hi,

    I am pulling my hair out trying to find out how to get a cell to display a related price when linked to a drop down list that is dependant on another drop down list.

    Ie, select company, select material = related price..

    simple....??? For some reason not!

    I am certain this is not a difficult thing to do if you know how, but if you dont it is ridiculous! I hope you might be able to help.

    Many thanks, Andrew
    Attached Files Attached Files
    Last edited by Solo Sails; 06-28-2011 at 12:03 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,525

    Re: Cell to display price when linked to drop down list

    Not so easy. Make sure that your company names are spelled correctly in the tabs and use something like this

    =VLOOKUP(B2,INDIRECT("'"&A2&"'"&"!A2:B10"),2,FALSE)

    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-27-2011
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Cell to display price when linked to drop down list

    Yes, that works for me!

    Thanks you I love you.

    Why on earth is this program so un user friendly, surely in this day and age there shouldn't be the need to program, GUI's WYSIWYG and all that!

    Anyway, you have now solved three days of time wasting, thanks.

+ 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