Results 1 to 2 of 2

Thread: Using And, if, or, ISNA statements

  1. #1

    Using And, if, or, ISNA statements

    Register for a FREE account, and/
    or Log in to avoid these ads!


    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.


    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    York, England
    Excel Version
    I'm a little confused by this. Surely accounts that are in Oct 2015 but not Nov 2014 are new accounts, and not deleted ones?
    Also, a formula can only return one result, so if you want to answer several questions, you would need a separate formula for each.
    Im sure there is a good reason, but why can't you store the period in which the account is added and deleted ?
    If I'm looking at Oct 2005, how do I identify an account that was deleted during that period? If it simply isn't there, then you can't
    establish the deletion without cross-checking all the records for Sep 2005.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts