Excel Function ISNA OR AND IF

[henrock24]

Hello

I've made a formula to see if an account was added, stayed the same or has been deleted. In this case I started with a tab of only October 2014 Account, made another one for just September 2014 and another one for November 2014. Currently, I am only able to make a formula to tell me "Which accounts in this October 2015 tabs were from September and which were added since September". I want to incorporate in the below formula, which accounts from October 2015 are not in November 2014 as "Accounts Deleted" (I've already made a formula for the October accounts that are not in Nov). COuld someone please help me!?


=IF(ISNA(VLOOKUP(G2,SEP2005 $G$2:$G$132648,1,FALSE)),"Account Added Since Sept","Sept Accounts")

I've added a file for your view. In the October 2015 tab columns "AO" mentions the "Account Added Since Sept" or "Sept Accounts". I wanted to incorporate Accounts in November not in October as "Deleted Accounts". The accounts info is on Column "G" in the November 2005 tab.


Thanks,

Hendrix