#VALUE! issue

[Steved]

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]

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

 

[Steved]

Thankyou.

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

--
Regards
Frank Kabel
Frankfurt, Germany


.