• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    IF statement with #NA Returned

    SirJB7, Much thanks for lending quick help to my struggle. Before registering I spent hours and many searches, reworking the statement with varied results, but not on the mark. I tested your statement ...it works like a champ. Much appreciated. - djb
  2. D

    IF statement with #NA Returned

    This statement works returning #na when no match found BUT I don't want #na. Preferably blank, 0 or - . I've tried a variety of reworks on the statement in an effort to replace #na with no success. Statement reads: =IF(C129=4,VLOOKUP(G129,Rate4!$B$5:$C$696,2,0),"") NOTE: Value in C129 is...
Back
Top