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