AboutPricing

Get instant live expert help on index match match

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    If you are not the person who wrote this INDEX(Sheet2!A:A,small(IF("N"=INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19))-ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),1,1)+1),1)) then dont think you can fix it. route it to him who wrote it.
    Solved by F. F. in 28 mins
    =INDEX(D48:E69,MATCH(E74,D74:D95,FALSE)2,2) Need help with index and match
    Solved by C. L. in 17 mins
    i need help with an index match match look up
    Solved by M. A. in 20 mins
    Stuck on an Index Match formula, need to match 2 criteria
    Solved by D. B. in 30 mins
    =INDEX(Table1[Consumption (GWh)],MATCH(A2,Table1[Period],0)) Getting an error message on my index match and don't understand why
    Solved by A. A. in 27 mins