0 values further issue

[brian.baker13]

Hi Guys

I have used
=IF(Original!C33="","",Original!C33)
to avoid pulling 0 numbers across but I have come across a secondary
problem where
=IF(A33>0,VLOOKUP(A33,'New Labour Standards'!$B$6:$C$990,2,FALSE)," ")
and other formula on the same row beggining with =IF(A33>0 are now
displaying #n/a entries.

I want these entries blank if a33 is blank

Thanks

Brian

 

[Pete_UK]

Change them to:

=IF(OR(A33="",A33<=0),"",VLOOKUP(A33,'New Labour Standards'!$B$6:$C
$990,2,FALSE))

Note that I have made it "" rather than " ".

Hope this helps.

Pete

 

[brian.baker13]

Change them to:

=IF(OR(A33="",A33<=0),"",VLOOKUP(A33,'New Labour Standards'!$B$6:$C
$990,2,FALSE))

Note that I have made it "" rather than " ".

Hope this helps.

Pete





- Show quoted text -

STONKING STUFF CHEERS

 

[Pete_UK]

You're welcome Brian - thanks for feeding back.

Pete