+ Reply to Thread
Results 1 to 3 of 3

Use existing database on sheet2 to look at database entries on sheet1. If match is found

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Rochester, NY
    MS-Off Ver
    2010
    Posts
    4

    Use existing database on sheet2 to look at database entries on sheet1. If match is found

    I have a static database on sheet2 that lists a bunch of recurring jobs TO BE DONE each month (including name, $ amount, type of work, etc). These jobs represent a small portion of the total jobs done each month.
    The total Jobs that ACTUALLY GET DONE each month are entered into database on sheet1 (which includes name, $amount, type etc., and other columns as well). I want to have the RECURRING jobs on sheet2 get marked as done when the ACTUAL work is entered onto sheet1.
    I've played around with nesting a MATCH function inside an INDEX but I'm not sure I'm on the right track. Any suggestions?

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Use existing database on sheet2 to look at database entries on sheet1. If match is fo

    Try with countifs

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Use existing database on sheet2 to look at database entries on sheet1. If match is fo

    Hi, Refer the attachment
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 12-22-2013, 01:16 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] If cell value on Sheet1 not found on Sheet2 copy row to Sheet2
    By Yxx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2013, 04:15 AM
  4. [SOLVED] Check Customer Database, if not found, update database.
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 05:11 AM
  5. Index and Match 3 entries in a Database
    By pauldaddyadams in forum Excel General
    Replies: 7
    Last Post: 01-18-2012, 06:16 AM

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