+ Reply to Thread
Results 1 to 4 of 4

Index Function/match Intersection?? ?

  1. 09-05-2013, 10:54 AM #1
    pAPERCLIP20
    pAPERCLIP20 is offline
    Registered User
    Join Date
    09-04-2013
    Location
    US
    MS-Off Ver
    EXCEL 2010
    Posts
    4

    Index Function/match Intersection?? ?

    Excel Wizards,

    I'm trying to find the formula that shows an answer by entering the column top value and row value. For example if B1=dog and A2= a. I want to be able to enter Dog in one lookup value and A in another to give me 10. I have attached the example. Your help is greatly appreciated. Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-05-2013, 11:01 AM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Index Function/match Intersection?? ?

    Try

    =INDEX(B2:D4,MATCH(H1,A2:A4,0),MATCH(G1,B1:D1,0))

    G1 = Dog
    H1 = A
    Reply With QuoteRegister To Reply
  3. 09-05-2013, 11:13 AM #3
    pAPERCLIP20
    pAPERCLIP20 is offline
    Registered User
    Join Date
    09-04-2013
    Location
    US
    MS-Off Ver
    EXCEL 2010
    Posts
    4

    Re: Index Function/match Intersection?? ?

    That'll do Thank you!
    Reply With QuoteRegister To Reply
  4. 09-05-2013, 11:14 AM #4
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Index Function/match Intersection?? ?

    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. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  2. Lookup or Index(match) function not in ascending order and not an exact match
    By Tobias1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  3. Index / Match to find value at point of intersection across multiple sheets
    By Pipes Chettiar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2012, 08:32 AM
  4. Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference
    By giallofever in forum Excel General
    Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  5. [SOLVED] Emulate Index/Match combo function w/ VBA custom function
    By Spencer Hutton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2005, 01:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1