AboutPricing

Get instant live expert help on indirect index 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

    Continuation of my last question... 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))
    Solved by M. J. in 30 mins
    Hello I'm having trouble doing the index match indirect across the board
    Solved by A. W. in 18 mins
    =IF($C$127="",VLOOKUP(B127,INDIRECT($B$128),10,FALSE),INDEX(INDIRECT($B$128),MATCH(1,(INDIRECT($B$129)=$B$127)*(INDIRECT($B$130)=$C$127),0),10)) shows me #N/A
    Solved by M. H. in 20 mins
    index,indirect,match,hlookup,different sheets,drop down lists,different tables sizes,buttons
    Solved by G. H. in 15 mins
    I am looking for help correcting an existing formula using index, indirect and match
    Solved by A. B. in 30 mins