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

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