Avoiding returning a 0 when no data in cell

S

Steve

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
 
D

Dave Peterson

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

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

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