+ Reply to Thread
Results 1 to 3 of 3

Lookup Debits & Credits

  1. 09-25-2012, 09:51 AM #1
    Sniper
    Sniper is offline
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    217

    Question Lookup Debits & Credits

    Good Afternoon

    I have a sheet with Debits and credits, I am looking for a formula to lookup the Debit Amount in the Credit Column where it's the same client - If it exist and the client is the same it must return a Y else a N. I did attach a sheet of what I mean.

    Thanks
    Attached Files Attached Files
    Last edited by Sniper; 09-25-2012 at 10:25 AM.
    Reply With QuoteRegister To Reply
  2. 09-25-2012, 10:05 AM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Lookup Debits & Credits

    Hi Sniper, try it (see formulae in green cells)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 09-25-2012, 10:25 AM #3
    Sniper
    Sniper is offline
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    217

    Re: Lookup Debits & Credits

    THANKS!!!!

    That is perfect
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1