+ Reply to Thread
Results 1 to 3 of 3

Drop down menu not working properly

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    Concord, California
    MS-Off Ver
    Excel 2010
    Posts
    13

    Drop down menu not working properly

    Hello,

    I have recieved much help from this forum already and my spread sheet is just about perfect, in my opinion,

    There is just one problem, I added some columns to my reference table "Price Table" and now the drop down menu on my "cabinets detail" sheet is not working.

    So just to clarify, On the "Cabinets Detail" sheet when an item number is entered then a description comes up and when a color is entered a price should appear but some of the colors return a "N/A" value in the price cells.

    All valid item numbers can be found on the sheet "Price Table"

    Can someone please help

    I have attached the file here

    Thank You
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Drop down menu not working properly

    MATCH(VLOOKUP($F33, ColorsKey, 2, 0) This part of your formulas evaluating to #NA the reason for that is the Vlookup returns J5/C066 What are you looking to get back from the Vlookup?
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  3. #3
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Drop down menu not working properly

    IF(OR($F33="",$A33=""), "", INDEX('Price Table'!$D$11:$R$500, MATCH($A33, 'Price Table'!$B$11:$B$500, 0),MATCH($F$33,'Price Table'!$D$7:$R$7,0)))

    think that fixes it,

+ 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