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