+ Reply to Thread
Results 1 to 4 of 4

Need help with Index IF Match Formula. Returning Room Number that Matches the Hours Used

  1. 03-21-2014, 01:05 PM #1
    KattieSpencer
    KattieSpencer is offline
    Registered User
    Join Date
    12-17-2013
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2013
    Posts
    10

    Need help with Index IF Match Formula. Returning Room Number that Matches the Hours Used

    Hey guys,

    I am trying to find a formula that populates a room number based on the number of hours used. I have a chart that is by building but multiple rooms within each.

    Where I am having trouble is when there are more than one room with the same number of hours used then sometimes the formula populates the wrong room number and I don't know how to fix this problem.

    Attached is my example spreadsheet of my chart. Book1.xlsx

    I have shown what I need, what I have tried and a blank space to show where I need it to go.

    Can anyone please help?!!!??
    Reply With QuoteRegister To Reply
  2. 03-21-2014, 01:17 PM #2
    AlKey
    AlKey is offline
    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: Need help with Index IF Match Formula. Returning Room Number that Matches the Hours Us

    Try this formula in E4

    =INDEX($K$2:$K$114,INDEX(MATCH(A4&D4,$J$2:$J$197&$L$2:$L$197,0),1))
    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 With QuoteRegister To Reply
  3. 03-25-2014, 12:12 PM #3
    KattieSpencer
    KattieSpencer is offline
    Registered User
    Join Date
    12-17-2013
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Need help with Index IF Match Formula. Returning Room Number that Matches the Hours Us

    Thanks AlKey this is exactly what I needed!!!
    Reply With QuoteRegister To Reply
  4. 03-25-2014, 12:22 PM #4
    AlKey
    AlKey is offline
    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: Need help with Index IF Match Formula. Returning Room Number that Matches the Hours Us

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
    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. Need Advice on Formula Index+Match (Multiple Matches) + IF
    By cychua in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-05-2013, 05:08 AM
  2. formula using INDEX/MATCH to retrieve multiple matches returned into one column
    By merlyn45 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-19-2013, 11:33 AM
  3. [SOLVED] INDEX MATCH array formula that matches substring n gives multiple matches
    By bkwins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 04:57 AM
  4. [SOLVED] VLOOKUP (or Index/Match) across four columns -- and returning multiple matches
    By rcasey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2013, 05:20 PM
  5. How to ignore blank matches with an index and choose the next match (if multiple matches)
    By Gooford in forum Excel General
    Replies: 4
    Last Post: 07-18-2012, 02:34 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