# 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.

## 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