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.
Bookmarks