0 values further issue

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

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
 
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
 
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 -
Click to expand...

STONKING STUFF CHEERS
 
Back
Top