Results 1 to 2 of 2

Thread: using formula changes dates to number

  1. #1
    Neophyte kartay's Avatar
    Join Date
    Jan 2015
    Location
    Iowa
    Posts
    3
    Articles
    0

    using formula changes dates to number



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    I am using this formula:

    IFERROR(VLOOKUP($A3,'main'!$A$2:$P$5000,MATCH(O$1,'main'!$A$1:$P$1,0),FALSE),"")

    and it works fine. But for the date fields it returns the number instead of the date. The column in the main tab (reference) is formatted as a date, but it doesn't carry that format over in the new tab (update). I can change all the formats in all the 17 update tabs manually, but then it it converts blanks to 1/0/1900 which then I have to manually delete. Is there something I can add to that formula or a vb fix for this?

    Thanks

    Kara

  2. #2
    Try

    =IFERROR(IF(VLOOKUP($A4,main!$A$2:$P$5000,MATCH(O$1,main!$A$1:$P$1,0),FALSE)=0,"",VLOOKUP($A4,main!$A$2:$P$5000,MATCH(O$1,main!$A$1:$P$1,0),FALSE)),"")

    and format as dates

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •