+ Reply to Thread
Results 1 to 2 of 2

Dynamic Calendar fixing VLOOKUP error for cells without information

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    30

    Dynamic Calendar fixing VLOOKUP error for cells without information

    Hello! Another user helped me better organize the dynamic calendar I'm trying to make, however when there is a missing date in the purchase date column in the input data sheet a weird date pops up in the date for next purchase column in the predictor for future sheet and I want to find a way to make it write "Missing" or something along those lines. Also is there a way to reference the hours on previous years too by extracting dates from the input data so that it would pop up like in the example for 2019? Thank you for your help!
    Attached Files Attached Files
    Last edited by cheeseleweese; 01-12-2021 at 06:22 PM.

  2. #2
    Registered User
    Join Date
    01-12-2021
    Location
    Brazil
    MS-Off Ver
    MS 365
    Posts
    2

    Re: Dynamic Calendar fixing VLOOKUP error for cells without information

    Hey, I'll try to help.

    The problem is that 0, when you format on day, its 00/01/1900.

    So what we need is to read that the day is empty, and turn it in some information.
    I added an IF case on the formula, checking if it was different from zero, and when false, returning the wording MISSING.

    This does not seam to break anything else in your work, however, I added a IFERROR in the "estimated time", just to keep it as clean as the other columns.


    Hope it helps, and you could understand why.
    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. [SOLVED] Conditional formating cells in a dynamic anual calendar
    By Konta in forum Excel General
    Replies: 4
    Last Post: 09-24-2019, 11:19 AM
  2. Replies: 2
    Last Post: 06-10-2019, 10:23 PM
  3. Insert text in whole calendar column (day) using Information from other cells
    By joelmoor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2019, 11:12 AM
  4. Need help fixing calendar (leap year)
    By jojo319 in forum Excel General
    Replies: 4
    Last Post: 03-25-2017, 05:32 AM
  5. [SOLVED] Dynamic Vlookup Formula to get information from different worksheets
    By BigDawg15 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-07-2013, 06:26 PM
  6. dynamic column indirect formula needs fixing
    By tsiguy96 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 12:24 AM
  7. [SOLVED] Fixing a vlookup macro that returns #N/A error
    By Grosvenor in forum Excel General
    Replies: 1
    Last Post: 02-08-2006, 08:30 AM

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