+ Reply to Thread
Results 1 to 3 of 3

Finding the intersecting point of table based off of two separate cells

  1. #1
    Registered User
    Join Date
    06-15-2022
    Location
    PA
    MS-Off Ver
    2016
    Posts
    7

    Smile Finding the intersecting point of table based off of two separate cells

    Ill try my best to explain this short and sweet

    I'm trying to take the Height and Width measurements and match them up to the charts axes on the right and then find the intersecting points within that chart to then pull that number and drop it in the "size factor" column

    EX: Height = 4"
    Width = 48"


    *Find 4" on Y AXIS and find 48" on X AXIS and the intersecting points of those row/columns*

    Size factor would = 1.92 (as shown on the chart)

    *put 1.92 in the "size factor" column on the same row as the original measurements (4 and 48)*

    I would like to have this automated with some sort of function but I have no idea what to use or how to word it.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,146

    Re: Finding the intersecting point of table based off of two separate cells

    Try

    =IFERROR(INDEX($K$6:$W$28,MATCH($B6,$J$6:$J$28,1),MATCH($C6,$K$5:$W$5,1)),"")

    NOTE: Width less than 24 will return blank
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    06-15-2022
    Location
    PA
    MS-Off Ver
    2016
    Posts
    7

    Re: Finding the intersecting point of table based off of two separate cells

    Thank you!

+ 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. Wants to calculate and show intersecting point on Graph
    By zaidu87 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-08-2022, 12:41 AM
  2. [SOLVED] Finding a value based on three criteria (two in a separate column, one in a separate row)
    By sepehr485 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-02-2022, 02:16 PM
  3. [SOLVED] Copy and append an array of cells based on a separate date table
    By concatch in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-09-2018, 06:23 PM
  4. Finding intersecting row and column on data chart based on data input...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2014, 08:09 PM
  5. Finding & Returning Data Based on 2 Parameters from a Separate Workbook
    By andrew.nelson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2013, 12:28 AM
  6. Replies: 5
    Last Post: 10-01-2009, 11:48 AM
  7. Table of intersecting data
    By HBM in forum Excel General
    Replies: 2
    Last Post: 08-14-2009, 09:59 AM

Tags for this Thread

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