The below formula worked great until I added the IFERROR. I then get an error that says i have to many levels of nesting. Please help me shorten if possible.
=iferror(HYPERLINK(CONCATENATE("[Credit Card.xls]",(ADDRESS(IF(NOT(ISNA(MATCH(F2,'Bank Statement'!$E:$E,0))),MATCH(F2,'Bank Statement'!$E:$E,0),IF(NOT(ISNA(MATCH(G2,'Bank Statement'!$E:$E,0))),MATCH(G2,'Bank Statement'!$E:$E,0),"No Match")),5,4,1,"Bank Statement"))),CONCATENATE("E",IF(NOT(ISNA(MATCH(F2,'Bank Statement'!$E:$E,0))),MATCH(F2,'Bank Statement'!$E:$E,0),IF(NOT(ISNA(MATCH(G2,'Bank Statement'!$E:$E,0))),MATCH(G2,'Bank Statement'!$E:$E,0),"No Match")))),"")
=iferror(HYPERLINK(CONCATENATE("[Credit Card.xls]",(ADDRESS(IF(NOT(ISNA(MATCH(F2,'Bank Statement'!$E:$E,0))),MATCH(F2,'Bank Statement'!$E:$E,0),IF(NOT(ISNA(MATCH(G2,'Bank Statement'!$E:$E,0))),MATCH(G2,'Bank Statement'!$E:$E,0),"No Match")),5,4,1,"Bank Statement"))),CONCATENATE("E",IF(NOT(ISNA(MATCH(F2,'Bank Statement'!$E:$E,0))),MATCH(F2,'Bank Statement'!$E:$E,0),IF(NOT(ISNA(MATCH(G2,'Bank Statement'!$E:$E,0))),MATCH(G2,'Bank Statement'!$E:$E,0),"No Match")))),"")