Results 1 to 3 of 3

Match and return a true false value

Threaded View

dcaraher Match and return a true false... 09-25-2009, 06:29 AM
sweep Re: Match and return a true... 09-25-2009, 06:36 AM
dcaraher Re: Match and return a true... 09-25-2009, 06:42 AM
  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Match and return a true false value

    I have atached a much simplified version of a spreadsheet I am using.

    I have a master spreadsheet which shows agreeed rentals for vehicles, on the sample this is the "OCS" tab.

    I receive a spreadsheet which contains the actual rental charged, in my example this is the tab "Invoice" in my example the VRN are in the same order on both sheets, in reality the invoice spreadsheet is not in the same order as my OCS sheet.

    My task is to match the VRN field in the invoice sheet to the VRN in the OCS sheet, then look at the amounts and if they match then return "true" if they don't return "false

    Thanks in advance for your help
    Attached Files Attached Files
    Last edited by dcaraher; 09-25-2009 at 06:43 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