ras408@yahoo.comDear Sir, I Ram Avtar Singh facing problems in Excel conditional Index match command. i need your help. but there in no file attachment option. kindly provide your Email so i can send my file and find solution of error. =INDEX(Data!$C$2:$C$498,SMALL(IF(Data!$B$2:$B$498=$C$17,ROW(Data!$B$2:$B$498)-ROW(Data!$B$2)+1),ROWS(H$17:H22))) when no other entry then formula giving #NUM!. kindly help me. my email id is ras408@yahoo.com
