I need help with this formula: =IFERROR(INDEX(Sales,MATCH(B22,CustID,0),MATCH(C22,SaleMonth,0)),IF(B22=0,"Must enter ID number FIRST in the merged cell B22",IF(7=ERROR.TYPE((MATCH(B22,CustID,0))),"NO RECORDS FOUND",IF(OR(AND((MATCH(B22,CustID,0))>0,C22=" "),AND((MATCH(B22,CustID,0))>0,ERROR.TYPE((MATCH(C22,SaleMonth,0)))=7)),"Acceptable Month values ARE April, May, June - case not important"))))
Solved by M. D. in 29 mins