ISERROR
Maybe,
=IF(ISERROR(IF(B591,VLOOKUP(A59,$D$3:$S$2423,14,F ALSE),"
")),"",IF(B591,VLOOKUP(A59,$D$3:$S$2423,14,FALSE) ," "))
Mike
"Jim" wrote:
Can anyone tell me how to get the ISERROR function in this function:
=IF(B591,VLOOKUP(A59,$D$3:$S$2423,14,FALSE)," ")
I have been trying, but to no avail.
|