Self resolved:

= IF(
ISERROR( VLOOKUP($A16,INDIRECT("'[NEW FNO EOD Data.xls]"&H
$3&"'!$B$2:$Z$500"), 8, FALSE) ),
0,
VLOOKUP($A16,INDIRECT("'[NEW FNO EOD
Data.xls]"&H$3&"'!$B$2:$Z$500"), 8, FALSE)
)

.....as easy as that.

Thanks anyway to group.

- KA