+ Reply to Thread
Results 1 to 3 of 3

IF Condition with Vlookup and Dates Involved

  1. #1
    Registered User
    Join Date
    07-01-2021
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    22

    Question IF Condition with Vlookup and Dates Involved

    Hello

    I would like to ask for the formula on this one. Here's the scenario

    Sheet 1 - Vlook up the column B(Name) - Vlook-up the completion date from "Data" tab, then if date exist the status on the "Final Status Column" should be "Completed" otherwise "Not Completed".

    I have attached the file for your reference.

    Thank You in Advance
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,194

    Re: IF Condition with Vlookup and Dates Involved

    In C2 copied down:

    =IF(B2="","Not ","")&"Completed"
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    07-01-2021
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    22

    Re: IF Condition with Vlookup and Dates Involved

    Hello Ali

    Thank you so much for your help.

+ 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: 12
    Last Post: 03-14-2019, 10:09 AM
  2. Need to find the number of dates between two repair dates with condition
    By prirosmail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2018, 04:05 PM
  3. [SOLVED] Identify and populate no. of shifts involved in between 2 dates
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 01-11-2018, 03:21 AM
  4. [SOLVED] Condition Formula between dates then sum if meets between those dates
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2017, 03:52 PM
  5. [SOLVED] .AutoFilter compatibility between Excel 2007 & Later versions when dates are involved
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2015, 10:00 AM
  6. Condition formating on due dates between a row of dates
    By irismarcial in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2012, 04:18 PM
  7. Counting Weeks INVOLVED between 2 dates
    By GuruWannaB in forum Excel General
    Replies: 4
    Last Post: 11-03-2008, 06:09 PM

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