+ Reply to Thread
Results 1 to 2 of 2

Trying to pull true and false on basis: if the dates and ID is available on tab 2.

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    India
    MS-Off Ver
    2011
    Posts
    1

    Question Trying to pull true and false on basis: if the dates and ID is available on tab 2.

    I am trying to pull a true/false value if a particular date range and Unique number is available on both the tabs.
    Tab 1 will have date range and Unique number in same row: Unique number, Start: 7/16 End: 7/20
    Tab 2 will have Unique number & a particular date let's say Unique ID + 7/17
    And if 7/17 + Unique number is available on Tab 1 it should say True and if not it should say false (on tab 2).

    How can we do that?

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: Trying to pull true and false on basis: if the dates and ID is available on tab 2.

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Do not try to use the Paperclip icon, as this does not work on this forum.

    Hope this helps.

+ 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. Compare dates and return true or false
    By Burt_100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2014, 04:00 PM
  2. Trying to use a True/False to pull data from another cell
    By melle_mel in forum Excel General
    Replies: 5
    Last Post: 07-20-2014, 11:01 AM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  5. True false statement with dates
    By hrclark in forum Excel General
    Replies: 3
    Last Post: 10-18-2011, 11:42 AM
  6. counting number of dates AND check for true false
    By Whisper1 in forum Excel General
    Replies: 1
    Last Post: 01-30-2007, 04:50 PM
  7. [SOLVED] Function that compares dates and returns TRUE or FALSE
    By Emily in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-25-2006, 04:30 PM

Tags for this Thread

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