You can do it this way

=IF(OR($I$2="Active",ISNA(VLOOKUP($E6,Data!$G$4:$A T$1587,28,0))),0,VLOOKUP($E6,Data!$G$4:$AT$1587,28 ,0))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=502284