Results 1 to 8 of 8

If reference A is in sheets 1 and 2, does the amount match exactly in both sheets?

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    81

    If reference A is in sheets 1 and 2, does the amount match exactly in both sheets?

    In a workbook I have two sheets.

    Sheet 1: Statement with 1000+ invoice numbers and amount etc (third party)
    Sheet 2: Download of invoices I have on my system

    I want to do a look up in 'sheet 1', to match off what I have or don't have from the third party statement.
    Therefore if invoice number on 'sheet 1' matches invoice number on 'sheet 2', do their corresponding figures match exactly? Yes or No. I assume if there is no invoice on my system (sheet2) the search would bring up a #N/A in sheet 1.

    Can I actually do this in one formula or would it be two different ones?
    Last edited by MushroomFace; 06-01-2013 at 10:26 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1