#VALUE! issue

Steved · Aug 30, 2004

Hello from Steved

=SUMPRODUCT(--(ParadoxBusType!$I$4=$B$34),ParadoxBusType!
L4)

The above formula gives me #VALUE! if their is no value in
the cell

I would like please to have the cell blank

If a lookup value is the answer I would implement this
into my spreadsheet to give me a blank cell.

Thankyou

Frank Kabel · Aug 30, 2004

Hi
why not use
=IF(ParadoxBusType!$I$4=$B$34,ParadoxBusType!L4,"")

Steved · Aug 31, 2004

Thankyou.

-----Original Message-----
Hi
why not use
=IF(ParadoxBusType!$I$4=$B$34,ParadoxBusType!L4,"")

--
Regards
Frank Kabel
Frankfurt, Germany

.