Entering a formula in formula results in an error.

  • I entered a formula, changed the string to Formula and put in the following formula.

    =IFERROR(INDEX(‘list’!B:C,MATCH(INDIRECT(ADDRESS(ROW(),COLUMN()-1)),’list’!A:A,-0)), “N/A”)

    This is a formula that when an inquiry sent by contact form7 comes into the spreadsheet, it will refer to the sheet called list and if it is applicable, it will be entered.

    However, when I add this formula, not only the error but also the output queue created by all add cells disappears and the above error occurs.

    Does anyone have a solution to this problem?
    Thank you very much for your help.

  • The topic ‘Entering a formula in formula results in an error.’ is closed to new replies.