+ Reply to Thread
Results 1 to 3 of 3

How to make VLOOKUP work with NOW function?

  1. #1
    Registered User
    Join Date
    12-26-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    69

    How to make VLOOKUP work with NOW function?

    Hi community,

    I have an Excel event calendar in MS One Drive which automatically shows today's event by using VLOOKUP.
    VLOOKUP works fine if I use the =TODAY() function as lookup value
    My problem is that One Drive from the company has a different system time.
    My local time is 15 hours ahead than the One Drive system time, it's from the company so I cannot change it.
    So I am using the =NOW() function and add the 15 hours, like this =NOW()+(15*(1/24)), but VLOOKUP doesn't work as it shows N/A error.
    I have attached a sample workbook to explain this.
    Can you help me please to solve this?
    I would like to make VLOOKUP work with the NOW function.
    Thanks a lot.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,776

    Re: How to make VLOOKUP work with NOW function?

    G6=vlookup(int(f6),a3:b5,2,false)

  3. #3
    Registered User
    Join Date
    12-26-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    69

    Re: How to make VLOOKUP work with NOW function?

    Thank you @CARACALLA
    It works!!!!
    Reps on the way!

+ 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. needing a VLOOKUP combination with something to make it work (I Think)
    By salkovsg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2015, 06:09 PM
  2. VLOOKUP, INDEX/MATCH, SUMIFS...cant make it work
    By kdk616 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2015, 01:34 AM
  3. [SOLVED] Trying to make a IF AND OR function work
    By JTM1200 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2012, 04:34 PM
  4. [SOLVED] Function Help - is IF or OFFSET I can't make it work
    By SKE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2012, 10:23 PM
  5. ISBLANK to make an IF function work.
    By Steve-B in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2009, 08:32 AM
  6. [SOLVED] How to make VLOOKUP work for this
    By DavidJ726 in forum Excel General
    Replies: 3
    Last Post: 05-13-2006, 01:25 PM
  7. Using SUM with VLOOKUP can I make it work for me?
    By Julia Osborne in forum Excel General
    Replies: 0
    Last Post: 03-03-2005, 11:36 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