+ Reply to Thread
Results 1 to 2 of 2

Find intersection of data on a chart.

  1. #1
    Registered User
    Join Date
    03-31-2019
    Location
    Spokane, WA
    MS-Off Ver
    Excel for Mac 2016
    Posts
    1

    Find intersection of data on a chart.

    I imagine this is a fairly straightforward issue but I'm trying to figure out how to grab a figure from the following chart:437-fuel-moisture-tablea.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,844

    Re: Find intersection of data on a chart.

    Looks like it should be a simple 2D lookup using the approximate match option in the MATCH() function (3rd argument is 1). Unfortunately, almost all of the lookup examples on the internet are all exact match examples, so one has to be aware of the approximate match option and try a few on their own to figure out how it works. Here's what I would do:

    0) If you are unfamiliar with Excel's INDEX() and MATCH() functions, review the help files and any other tutorials you are familiar with:
    https://support.office.com/en-us/art...2-b56b061328bd
    https://support.office.com/en-us/art...9-533f4a37673a
    1a) Assuming you are allowed to edit the lookup table, enter the lower limits for the dry bulb temparatures. A2 is 10, A3 is 30, A4 is 50, etc.
    1b) Enter the lower limits in the relative humidity row. B1 is 0, C1 is 5, D1 is 10, and so on.
    2) Use a MATCH() function to return the row number =MATCH(dry_bulb_temp,$A$2:$A$7,1)
    3) use another MATCH() function to return the column number =MATCH(relative_humidity,$B$1:$V$1,1)
    4) Use an INDEX() function to return the final result =INDEX($B$2:$V$7,result of 2,result of 1) or, if you feel a desperate need to nest those functions into one =INDEX($B$2:$V$7,MATCH(dry_bulb_temp,...),MATCH(relative_humidity,...).

    Will that work for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates
    By Paddy_Bear in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-03-2018, 03:36 AM
  2. [SOLVED] Find the intersection using arrays
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2017, 03:42 PM
  3. [SOLVED] I want to show the intersection point in the chart....
    By pwnyadav007 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-07-2017, 10:32 AM
  4. shading above/below intersection areas in line chart
    By BigL76 in forum Excel General
    Replies: 2
    Last Post: 07-05-2010, 11:46 AM
  5. How do I find a value at the intersection of a column and a row?
    By brianalucas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2010, 08:02 PM
  6. Match data to find intersection
    By Shannon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-07-2006, 12:30 PM
  7. [SOLVED] find a value at an intersection?
    By Ellen G. in forum Excel General
    Replies: 4
    Last Post: 06-29-2006, 03:40 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