Avoiding returning a 0 when no data in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 05 Feb 2007 21:50 GMT

I have worked out the formula I need to use (with help from someone
from this group).

However how do I stop it returning a 0 when no data is present in the
cell?

My formula:

=VLOOKUP($G37,Staffing!$C:$AL,36,FALSE)

Many thanks

Steve

Reply to this Message

Dave Peterson - 05 Feb 2007 22:10 GMT

=if(vlookup(...)="","",vlookup(...))

You may want to suppress the #n/a error, too:

=if(iserror(vlookup(...)),"",if(vlookup(...)="","",vlookup(...)))

> I have worked out the formula I need to use (with help from someone
> from this group).
[quoted text clipped - 9 lines]
>
> Steve

Signature

Dave Peterson

Reply to this Message