Hi Can anyone advise if there is an easier and less complicated way to

achieve the following :


Hi. I like to use Range Names for Tables.
If any error is ok, perhaps with Excel 2007...
(not tested!)

=SUM(
$C127,
IFERROR(VLOOKUP($A124,TblAB,2,0),0),
-IFERROR(VLOOKUP($A124,TblDE,2,0),0)
)

--
HTH :)
Dana DeLouis


"Alexey" wrote in message ...

Hi Can anyone advise if there is an easier and less complicated way to
achieve the following :

=SUM($C127+(SUM(IF(ISNA(VLOOKUP($A124,MISDATA!$A$3 :$B$5000,2,0)),0,VLOOKUP($A124,MISDATA!$A$3:$B$500 0,2,0))-(IF(ISNA(VLOOKUP($A124,MISDATA!$D$3:$E$5000,2,0)), 0,VLOOKUP($A124,MISDATA!$D$3:$E$5000,2,0))))))

Thanks

A