Vlookup help

[Ks1102]

=IF(ISNA(VLOOKUP($B3,FXF169!$B$3:$E$21,2,FALSE)),0+IF(ISNA(VLOOKUP(Summary!$B3,FXF155!$B$3:$E$19,2,FALSE)),0+IF(ISNA(VLOOKUP(Summary!$B3,FXF078!$B$3:$E$19,2,FALSE)),0+IF(ISNA(VLOOKUP($B3,FXF023!$B$3:$E$21,2,FALSE))),0))

Hi, all
please help me which formula which part get wrong as it to have sum multiple worksheet if = B3 criteria


thanks very much the help

 

[niceguy_jay]

 =IF(ISNA(VLOOKUP($B3,FXF169!$B$3:$E$21,2,FALSE)),0+IF(ISNA(VLOOKUP(Summary!$B3,FXF155!$B$3:$E$19,2,FALSE)),0+IF(ISNA(VLOOKUP(Summary!$B3,FXF078!$B$3:$E$19,2,FALSE)),0+IF(ISNA(VLOOKUP($B3,$B$3:$E$21,2,FALSE)),"",""),0)))

 

[Ks1102]

 =IF(ISNA(VLOOKUP($B3,FXF169!$B$3:$E$21,2,FALSE)),0+IF(ISNA(VLOOKUP(Summary!$B3,FXF155!$B$3:$E$19,2,FALSE)),0+IF(ISNA(VLOOKUP(Summary!$B3,FXF078!$B$3:$E$19,2,FALSE)),0+IF(ISNA(VLOOKUP($B3,$B$3:$E$21,2,FALSE)),"",""),0)))

thanks so much