+ Reply to Thread
Results 1 to 4 of 4

Dropdown menu X-axis, Y-axis to find a value in a table?

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    Oslo
    MS-Off Ver
    Office 365 V.2201 / Win11
    Posts
    17

    Dropdown menu X-axis, Y-axis to find a value in a table?

    Evening!
    i was wondering if i could get som asistance?
    i have two dropmenus that are made from datacollection "list", with an X-axis and a Y-axis
    as the image refers to below.
    i was wondering how can i get it so when i select both an X-axis value, and a Y-axis value it displays the corresponding number?
    ie. if i select 20 and 20 it should display 130,6 l/s *ha
    the list is dynamic, so slight changes when i select a different IVF curve, else i would just have done it with a alot of "if" commands.



    x-y.png
    table.png
    final result.png
    Attached Images Attached Images
    Last edited by andreasnw; 02-15-2022 at 05:59 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Dropdown menu X-axis, Y-axis to find a value in a table?

    Without a sample workbook (see banner at the top of the page), there is limited help that can be offered.

    I suspect the solution would be to define the "table" in terms of a named dynamic range with additional ranges for the X and Y axis and then use INDEX / MATCH to find the cell at the intersection.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    09-16-2013
    Location
    Oslo
    MS-Off Ver
    Office 365 V.2201 / Win11
    Posts
    17

    Re: Dropdown menu X-axis, Y-axis to find a value in a table?

    see attached workbook, i think i did add the attachment correctly?

    Table is is in IVF sheet
    and dropdown menues are in sheet1 (dimensjonerende kriterier) , cell C36/37 and C42/43
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-16-2013
    Location
    Oslo
    MS-Off Ver
    Office 365 V.2201 / Win11
    Posts
    17

    Re: Dropdown menu X-axis, Y-axis to find a value in a table?

    Problem solved, incorperated index and match functions and got it working
    Last edited by andreasnw; 02-16-2022 at 03:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  2. Replies: 5
    Last Post: 01-07-2017, 03:17 PM
  3. [SOLVED] formula to find certain number in a table when x axis and y axis are matched
    By Willem72 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-22-2015, 08:42 AM
  4. Dropdown Menu in Line Chart and Y axis scale
    By katknight32 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-19-2013, 02:29 PM
  5. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  6. Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis
    By mw210461@yahoo.com in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2005, 05:05 PM
  7. How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM

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