📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel Issue

Cotta
Cotta Posts: 3,667 Forumite
Morning All,

I have the following formula included to pull dates and where the cell contains no date I want it to appear blank, however when the cell is blank it returns 0/01/1900, is there anyway to correct this?
Below is the code I use:

=IFERROR(VLOOKUP(O3,'Dates'!E:G,3,FALSE),"")

Comments

  • bod1467
    bod1467 Posts: 15,214 Forumite
    =IFERROR(VLOOKUP(O3,'Dates'!E:G,3,FALSE)," ")

    Change null string to a space?
  • Tried it on Excel 2010 and your formula does give a blank cell but if formula is =IFERROR(VLOOKUP(O3,'Dates'!E:G,3,FALSE),O3) and the cells are formatted as dates you get the 00/01/1900 you describe.


    =IF(ISBLANK(O3),"",IFERROR(VLOOKUP(O3,E:G,3,FALSE),""))


    should work.
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 355.9K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.2K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.