Results 1 to 6 of 6

lookup

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    86

    lookup

    Hi
    I have two tables that list customers by account number order and the limit of their account. What I would like to do is compare month to month so I can see if we have increased or decreased any account limits, added any new customers and their limits or removed any customers and their limits
    Column "U" I have a formula that returns if the customer held an account with us the month before, in column "V" I would like the difference between this months and last months Overdraft limit. Unfortunately I cant just minus one from the other as the rows can change from month to month as new accounts are added and old accounts leave. (example shows this)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Two Lookup and Return (Lookup the column, then lookup the row)
    By Branbran10 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 04:55 PM
  2. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  3. Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  4. Replies: 2
    Last Post: 05-19-2013, 08:46 AM
  5. Replies: 1
    Last Post: 11-07-2012, 01:57 PM
  6. Search lookup array to find lookup value contained within text string
    By Cookstein2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2011, 09:42 AM
  7. Replies: 7
    Last Post: 06-19-2011, 12:51 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1