Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: [Solved] VLOOKUP Date format

  1. #1
    Join Date
    29th July 2003
    Location
    Sydney, New South Wales
    Posts
    38
    Does anyone know why I cannot get my VLOOKUP and CONCATENATE to display the dates?

    =DATEVALUE(CONCATENATE(VLOOKUP(L22,Billing,8,FALSE)))

    I keep getting a #VALUE!

    The function looks up two date fields. I want it to display as per example:
    24-Mar-03 : 5-May-03

    thanks
    happy colin

  2. #2
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678
    DATEVALUE converts a date in the form of text to a number in XL date - time code

    CONCATENATE concatenates text strings

    Your VLOOKUP may return text string 1, but where is the other value you want to concatenate??

    Say C16 and D16 contain two dates
    placing this in D17
    =TEXT(C16,"dd-mmm-yy")&":"&TEXT(D16,"dd-mmm-yy")

    will return a value of
    01-Jan-03:02-Jan-03

    Hope this helps
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  3. #3
    Join Date
    29th July 2003
    Location
    Sydney, New South Wales
    Posts
    38
    Thanks WillR

    that fixed the problem. you saved me hours of frustration.
    happy colin

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. ComboBox date format and Vlookup
    By DesM in forum EXCEL HELP
    Replies: 6
    Last Post: May 14th, 2005, 00:21
  2. [Solved] VBA : customising date format
    By enigma in forum EXCEL HELP
    Replies: 2
    Last Post: May 4th, 2004, 21:33
  3. [Solved] FORMAT DATE
    By sal21 in forum EXCEL HELP
    Replies: 4
    Last Post: February 10th, 2004, 20:19
  4. [Solved] Formulas: Vlookup Format Challenge
    By flbritt in forum EXCEL HELP
    Replies: 7
    Last Post: November 1st, 2003, 02:24
  5. ListBox Date Format [SOLVED]
    By hillssh in forum EXCEL HELP
    Replies: 7
    Last Post: May 2nd, 2003, 20:10

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
  •  
porno