Hello all,
I can't fiqure out the proper formula using ISNA. Basically if a number appears on another sheet then I want to the cell to state "Customer Requires a P.O. For Payment" othewise I want the cell to be blank. Here is the formula I have and it works except for the instead of a blank cell i recieve a #NA:
=IF(VLOOKUP(B9,Accounts!A1:A500,1,0),"CUSTOMER REQUIRES P.O. FOR PAYMENT.",FALSE). Whenever I try the ISNA I recieve a formula error. I checked out this forum and read KenWrights comments
"=IF(ISNA(Your_Formula),"",Your_Formula)"
and for the life of me i just can't get it to work. HELP!!!
I can't fiqure out the proper formula using ISNA. Basically if a number appears on another sheet then I want to the cell to state "Customer Requires a P.O. For Payment" othewise I want the cell to be blank. Here is the formula I have and it works except for the instead of a blank cell i recieve a #NA:
=IF(VLOOKUP(B9,Accounts!A1:A500,1,0),"CUSTOMER REQUIRES P.O. FOR PAYMENT.",FALSE). Whenever I try the ISNA I recieve a formula error. I checked out this forum and read KenWrights comments
"=IF(ISNA(Your_Formula),"",Your_Formula)"
and for the life of me i just can't get it to work. HELP!!!