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!”
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