Maybe:

=IF(K49=0,MIN(K4:K38),if(count(j4:k38)=0,"",LOOKUP (MAX(J4:J38),K4:K38)))

or maybe...

=IF(K49=0,MIN(K4:K38),
if(or(count(j4:j38)=0,count(k4:k38)=0),"",LOOKUP(M AX(J4:J38),K4:K38)))



belvy123 wrote:

Hi All

I am using the following formula

=IF(K49=0,MIN(K4:K38),LOOKUP(MAX(J4:J38),K4:K38))

with this formula if K49 is not equal to 0 and there is no value in J4:J48
and K4:K48
It returns a #NA .
For the most part this is not a functional problem but more of an asthetic
issue.
What can I add to this formula to get it to return a Blank cell if there is
no value in
J4:J48 and K4:K48.
This will tidy up my sheet and make it look much nicer

Thanks

Dan N

crunchnin numbers

--

Dave Peterson