+ Reply to Thread
Results 1 to 5 of 5

How to get a result from a table (vertical+horizontal)

Hybrid View

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    Argentina
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to get a result from a table (vertical+horizontal)

    Hi everyone, I have something similar to the following table (but much larger) and I need to get specific values, based on info entered in other range:

    ________________________________________________
    │ 1 │ 2 │ 3 │ 4 │
    ________________________________________________
    a │ 2.5 │ 2.6 │ 2.7 │ 2.8 │
    ________________________________________________

    b │ 3.5 │ 3.6 │ 3.7 │ 3.8 │
    ________________________________________________

    c │ 4.5 │ 5.6 │ 6.7 │ 7.8 │
    ________________________________________________

    d │ 5.5 │ 6.6 │ 7.7 │ 8.8 │
    ________________________________________________

    For example, I have two other cells separated from the table showing "b" and "2".. so I need to get the result 3.6 in a third cell... how can I do this??
    Thank you!!

  2. #2
    Registered User
    Join Date
    01-04-2013
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: How to get a result from a table (vertical+horizontal)

    Hi use the following formula

    =INDEX(B2:E5,MATCH(A10,A2:A5,0),MATCH(B10,B1:E1,0))

    Please note A10 and B10 is where I have pleace "b" and "2"

    B2:E5 is the Data table not including the (a,b,c,d) and (1,2,3,4)
    A2:A5 is the (a,b,c,d) and B1:E1 is the (1,2,3,4) of the table

  3. #3
    Registered User
    Join Date
    05-14-2013
    Location
    Argentina
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to get a result from a table (vertical+horizontal)

    Thank you for the prompt response!! It was easier than what I thought! It worked!! :D :D :D

  4. #4
    Registered User
    Join Date
    01-04-2013
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: How to get a result from a table (vertical+horizontal)

    Hi can you mark this as solved and use the star to rate my response

    Thanks

  5. #5
    Registered User
    Join Date
    05-14-2013
    Location
    Argentina
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to get a result from a table (vertical+horizontal)

    Sure! Thanks :D

+ 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. Lookup Table Using Horizontal and Vertical Criteria
    By bbmonkey87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2014, 06:31 PM
  2. [SOLVED] Horizontal and vertical VLOOKUP in a table
    By Bax in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2014, 07:10 AM
  3. [SOLVED] Turning a Vertical Table into a Horizontal one
    By Rob8489 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2013, 10:03 AM
  4. [SOLVED] Convert Horizontal Table to Vertical List
    By TXboiler in forum Excel General
    Replies: 3
    Last Post: 04-22-2011, 09:27 PM
  5. Lookup from a Horizontal Table, not Vertical List
    By DMDG in forum Excel General
    Replies: 3
    Last Post: 07-23-2010, 01:53 PM

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