Results 1 to 3 of 3

Drop Downs & Tables

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Drop Downs & Tables

    Here attached is my issue. I have 30+ tables all representing different products by width and by height. All products have different dimensions available. When I add a table to the drop down(B2) and ask the user to choose the series they want pricing on, then choose the sizes required(C2&D2), is there a way to draw only the widths and heights available for that table? Or does the drop down for width and height have to incorporate all possible sizes for all available tables?
    This becomes confusing to figure out where one series size stops and another begins.
    Thanks in advance for any help!!!

    this is my formula for finding and matching the tables currently.

    =IF(COUNTBLANK(B2:E2)=2,0,INDEX(INDIRECT(B2),MATCH(E2,INDEX(INDIRECT(B2),0,1),0),MATCH(D2,INDEX(INDIRECT(B2),1,0),0)))
    Attached Files Attached Files
    Last edited by mojobaabby; 09-04-2010 at 02:14 PM.

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