+ Reply to Thread
Results 1 to 3 of 3

Get value based on columns and row headers

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Nova Scotia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Get value based on columns and row headers

    Hello,

    I've attached an example file to better explain what I'd like to accomplish.


    example.xlsx


    I would like to be able to type numbers into the yellow cells (Temperature and specific gravity), and populate the "K factor" cell using the table above. For example, if I enter this information:

    Temperature: 20
    Specific Gravity: 2.65

    Then the cell after "K factor" will read 0.01365

    I've experimented with VLOOKUP and INDEX, but still can't figure it out.

    Thanks

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Get value based on columns and row headers

    Using your posted workbook...try this regular formula:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Get value based on columns and row headers

    In B23

    =SUMPRODUCT((A3:A17=B21)*(B2:J2=B22)*(B3:J17))
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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] Hide columns based on dynamic headers
    By pdalal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2013, 03:21 AM
  2. [SOLVED] Copy pasting columns based on headers
    By krash297 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2013, 02:13 PM
  3. [SOLVED] Delete entire Columns based on different Headers (Array)
    By WITJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2013, 02:46 PM
  4. Excel 2007 : Macro to copy columns based headers
    By rls1316 in forum Excel General
    Replies: 2
    Last Post: 04-25-2011, 10:22 PM
  5. Macro to Sum Columns based on Headers
    By Jluc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2011, 02:36 PM

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