+ Reply to Thread
Results 1 to 3 of 3

Match and return a true false value

Hybrid View

  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.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,454

    Re: Match and return a true false value

    Hi,

    In your invoice sheet, in cell C2,

    =B2=INDEX(OCS!$B$2:$B$8,MATCH(Invoice!A2,OCS!$A$2:$A$8,0))

    copied down should give you the result you want
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Re: Match and return a true false value

    Sweep

    Many thanks for your very prompt reply, that does the job.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1