Results 1 to 9 of 9

Need to find the intersection within a table but output a cell within the same column

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    3

    Need to find the intersection within a table but output a cell within the same column

    Size of Tubing 16 21 27 35 41 53 63 78 91 103 116 129 155
    AWG 14 12 22 36 62 85 140 200 200 200 200 200 200 200
    AWG 12 9 16 26 45 62 102 145 200 200 200 200 200 200
    AWG 10 5 10 16 28 38 63 90 139 187 200 200 200 200
    AWG 8 3 5 9 16 22 36 52 80 100 138 173 200 200

    Basically need to find the "Size of Tubing" based on "AWG #" (input 1) and another number within the body of the table. I need to find the intersection in the table but then output the intersection of the same column and the first row.

    Example. If I input AWG 12 and input 16 how do i get the output 21?

    Please help.
    Last edited by laona; 09-20-2014 at 09:27 AM. Reason: solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 07-28-2013, 05:40 PM
  2. [SOLVED] Search formula to find intersection of column and row
    By parky58 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2012, 04:01 PM
  3. Nested Formula to find intersection in table
    By RTE in forum Excel General
    Replies: 1
    Last Post: 06-09-2011, 10:01 AM
  4. 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
  5. Replies: 3
    Last Post: 07-17-2007, 09:43 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