Ok, this is what i have in the relevant cells...

D8
=IF(ISNA(VLOOKUP(A8,data!$C$2:$J$2971,3,FALSE)),"" ,VLOOKUP(A8,data!$C$2:$J$2971,3,FALSE))

E8
=SUM(D5*0.9*0.9)

Now if No data is entered in reference cell (A8), E8 just returns
#VALUE!, but i want it blank so the sheet is nice and tidy...
is this possible?

cheers again in advance
barry


--
bazza825
------------------------------------------------------------------------
bazza825's Profile: http://www.excelforum.com/member.php...o&userid=33241
View this thread: http://www.excelforum.com/showthread...hreadid=537382