 # Get instant live expert help on iferror 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

Need help with formula combining INDEX/MATCH with IFERROR statement.
Solved by M. J. in 18 mins
How can I combine the following two formulas? E11 in the index/match needs to search for either the E11 or D11 value. =IFERROR( INDEX(Unaccntd!\$B\$2:\$BL\$150, MATCH("Unaccounted",Unaccntd!\$B\$2:\$B\$150,0), MATCH(E11,OFFSET(Unaccntd!\$B\$2:\$BL\$2,0,-1),0) ),"") IFERROR(VLOOKUP(E11, Unaccntd!\$B\$2:\$BL\$150 ,FALSE),IFERROR(VLOOKUP(D11, Unaccntd!\$B\$2:\$BL\$150 ,FALSE),""))
Solved by C. S. in 21 mins
I have a formula not working. =IFERROR(INDEX(\$AA\$6:\$BL\$305,ROW(Z6)-2,MATCH(\$Z6,\$AA\$5:\$BL\$5,)),"")
Solved by G. D. in 19 mins
hello i need help fixing this formula: =IFERROR(INDEX(Shifts!\$E\$2:\$E\$1000,MATCH(\$A3,Shifts!\$B\$2:\$B\$1000,0))&"-"&INDEX(Shifts!\$F\$2:\$F\$1000,MATCH(\$A3,Shifts!\$B\$2:\$B\$1000,0))) it goes in D3 of thursday sheet
Solved by K. B. in 30 mins
Would someone be able to help decode that this means: =IFERROR(IFERROR(INDEX('Incoming List'!\$B\$3:\$B\$1000,MATCH(EOMONTH(F18,0),IF(D18='Incoming List'!\$G\$3:\$G\$1000,'Incoming List'!\$A\$3:\$A\$1000),0)),INDEX('Incoming List'!\$B\$3:\$B\$1000,MATCH(EOMONTH(F18,0),IF(E18='Incoming List'!\$G\$3:\$G\$1000,'Incoming List'!\$A\$3:\$A\$1000),0))),"")
Solved by K. D. in 24 mins