I would use another cell with this formula:

Assume this formula is in cell A1:

=COUNT($B$122:$AF$122,$B$116:$AF$116,$B$110:$AF$11 0,$B$104:$AF$104,
$B$98:$AF$98,$B$92:$AF$92,$B$86:$AF$86,$B$80:$AF$8 0,
$B$74:$AF$74,$B$68:$AF$68,$B$62:$AF$62,$B$56:$AF$5 6)

Then refer to that cell:

=IF(A1=0,"-",your_formula)


--
Biff
Microsoft Excel MVP


"sony654" wrote in message
...
The below function is producing exactly the result I want when I have a
value entered in the LOOKUP range. But, if no values entered in the
LOOKUP
range t returns the #N/A error. How do I edit this function result to
display "-", or blank if a value is not entered in the LOOKUP range?
Thanks
for your help. Sony

=LOOKUP(BigNum,CHOOSE(MATCH(TRUE,COUNTIF(INDIRECT( {"b122:af122","b116:af116","b110:af110","b104:af10 4","b98:af98","b92:af92","b86:af86","b80:af80","b7 4:af74","b68:af68","b62:af62","b56:af56"}),"<")0 ,0),$B$122:$AF$122,$B$116:$AF$116,$B$110:$AF$110,$ B$104:$AF$104,$B$98:$AF$98,$B$92:$AF$92,$B$86:$AF$ 86,$B$80:$AF$80,$B$74:$AF$74,$B$68:$AF$68,$B$62:$A F$62,$B$56:$AF$56))




--
Sony Luvy