Dear Chandra,
Please try it..in excel 2003 version
=IF(ISERROR(INDEX(Data!$A$3:$A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4))),"",INDEX(Data!$A$3:$A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$E$640,1)),0,S
Try by using as below
=if(iserror(formula),on error,formula)
Thanks and Regards,
Somnath C Pardeshi
Sent from BlackBerry® on Airtel
-Original Message-
From: chandra sekaran
Sender: excel-macros@googlegroups.com
Date: Mon, 27 Feb 2012 10:24:13
To:
Reply-To: excel-macros@googlegroups.c
