+ Reply to Thread
Results 1 to 4 of 4

Two dimensional lookup return column header

  1. 09-24-2016, 01:48 PM #1
    stephboucher
    stephboucher is offline
    Registered User
    Join Date
    01-18-2011
    Location
    Somerset
    MS-Off Ver
    Excel 2010
    Posts
    28

    Two dimensional lookup return column header

    Hi

    i need to lookup two values within a table and return the column header matching the criteria.

    please see attached for my example.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-24-2016, 02:01 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Two dimensional lookup return column header

    Try this...

    =INDEX(B1:G1,MATCH(J2,INDEX(B2:G5,MATCH(I2,A2:A5,0),0)))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 09-24-2016, 02:20 PM #3
    stephboucher
    stephboucher is offline
    Registered User
    Join Date
    01-18-2011
    Location
    Somerset
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Two dimensional lookup return column header

    thanks Tony
    Reply With QuoteRegister To Reply
  4. 09-24-2016, 02:24 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Two dimensional lookup return column header

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup row value(s) and return column header
    By robertdouglasC in forum Excel General
    Replies: 10
    Last Post: 06-28-2016, 01:25 AM
  2. How to lookup value in table and return column header
    By Zimmerman in forum Excel General
    Replies: 3
    Last Post: 03-14-2016, 08:53 AM
  3. Using Lookup to Return Column Header or Index Function to return revised pay rate
    By lovesexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2013, 12:38 PM
  4. Lookup value, return column header
    By jvp123 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-28-2012, 10:50 AM
  5. Lookup Row, Return Column Header
    By matt4003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2010, 07:43 AM
  6. Lookup Value in Range/Array and Return Column Header Value
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2006, 02:10 PM
  7. 2 Dimensional Lookup by column & rows to return score grade
    By loscherland in forum Excel General
    Replies: 2
    Last Post: 04-18-2006, 07:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1