Jasmine,


=IF(ISNA((INDEX('C:\Trend Cards\All New Renewed\[April New
Renew.xls]Sheet1'!$H$3:$H$5000,MATCH("CSFS Totals",'C:\Trend Cards\All
New
Renewed\[April New Renew.xls]Sheet1'!$B$3:$B$5000,0)+1))/1000),0,
(INDEX('C:\Trend Cards\All New Renewed\[April New
Renew.xls]Sheet1'!$H$3:$H$5000,MATCH("CSFS Totals",'C:\Trend Cards\All
New
Renewed\[April New Renew.xls]Sheet1'!$B$3:$B$5000,0)+1))/1000)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=547186