How to use IF and IFERROR together

[MLSNetworks]

Hello - I need advice/help using an IF and IFERROR formula together.

I pull account data each week with tabs for the individual week in the worksheet and I want to do a compare between the current week and the previous week to see what text has changed from week to week on all the accounts (~100).

I came up with the following formula using an IF formula and a VLOOKUP to show TRUE or FALSE if the text for that account is the same as the previous week (i.e., TRUE if the text is unchanged and FALSE if the text is different) and this works perfectly. But there are situations where Week 1 has no text and Week 2 has text and in those cases, I get an #N/A (error) in the cell so I want to put in an IFERROR to show the word FALSE when this happens.

However, using the following formula returns a 0 and not the word FALSE and also gives me a circular reference. What am I doing wrong and what would be the right formula to use?

=IF(VLOOKUP(B15,'Dependency Cert Data 1-20'!B:N,3,FALSE)=D15,"TRUE","FALSE")=IFERROR(T15,"FALSE")

Thank you for any help!

 

[jasonb75]

You shouldn't need IF for that, just IFERROR.

=IFERROR(VLOOKUP(B15,'Dependency Cert Data 1-20'!B:D,3,FALSE)=D15,FALSE)

I've also change B:N to B:D. Having the range extended past the columns that are being used does nothing more than make the formula inefficient.
As you say there are ~100 accounts, I assume that you only have ~100 rows of data, in which case you could make the formula more efficient by changing B:D to $B$1:$D$200 (200 rows of data) excluding the other 1 million plus rows that are not needed.

 

[MLSNetworks]

Thank you, Jasonb75! That worked perfectly. I was obviously making the formula too complicated. Thank you so much for simplifying it