Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Question Unanswered: Table Data Retrieval Issues

    I am trying to set up a spreadsheet based off of several different tables of information. I have cells with pulldown lists in them. These lists form the column and row titles of these tables... I want to be able to select these pulldowns and in a third cell have the results of those pulldowns produce the corresponding cell in the table they apply to.

    I have tried VLOOKUP, HLOOKUP and others but these formulas require that I enter the column or row number, but doesn't let me compare the names in the rows and columns with those I selected from the pulldown lists. The formulas get too long if I am to assign each row/column header with a number.

    For example, I have two pulldown cells: one pulldown choice is "Group Type" and I choose "Group B". Another is "Construction Type" and I select "Type I-A"... The table looks like this:

    A B C D
    1 Type I-A Type I-B Type II-A
    2 Group A 10,000 20,000 30,000
    3 Group B 15,000 25,000 35,000
    4 Group C 20,000 25,000 30,000

    I want a stand-alone third cell to automatically produce "15,000". If I then go back and change my pull-down selections, this result changes accordingly.

    If this makes sense, can anyone be of assistance? Thanks.
    Last edited by wildlobo71; 01-14-05 at 18:39.

  2. #2
    Join Date
    Oct 2003
    If I understand you correctly, you could concatenate into another cell, then base the retrieval on the concatenated values. But I suspect I haven't fully understood.

    Can you post a sample that has the data, and then what you desire to show up in a specific cell?
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2005
    Sample Data:

    My pulldown lists:

    List One: Group A-1, Group A-2, Group B, Group E, Group M, etc...

    List Two: Type I-A, Type I-B, Type II-A, Type II-B, etc..

    My Table consists of columns with the Groups in them, rows with the Types in them. Here is the table:

    A-1 UL UL 15,500 sf 8,500 sf
    A-2 UL UL 15,500 sf 9,500 sf
    A-3 UL UL 15,500 sf 9,500 sf
    A-4 UL UL 15,500 sf 9,500 sf
    A-5 UL UL UL UL
    B UL UL 37,500 sf 23,000 sf
    E UL UL 26,500 sf 14,500 sf

    So, if in one pulldown list I select "A-2", and in the other pulldown list I select "Type II-A", in a 3rd cell, I want "15,500 sf" to appear. If I change the pulldown to "B", I want the 3rd cell to change to "37,500 sf".

    This is my goal.


Posting Permissions

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