I have a Google Sheet with my wife where we both enter our upcoming events. They are included in named ranges and passed to the main sheet where the information is displayed. For example, I enter in the Event Scheduler:
01/01/2000 | 06:00 | Take the dog for a walk, where each
| is a new cell. I then generate a datetime with say
A1&A2, this usually comes out to be some number with a decimal like
06:00:00. I've now tried the following commands:
where MolliesEvents is a list of Mollies Events organised as follows:
date | time | | description | unique ID | datetime so the TODAY()&E14 = 442770.479166666666666, and INDEX(MolliesEvents,A13:A1000,6) = [...,442770.479166666666667,...]
where the ...'s are just other date&time combinations. Clearly, these two are the same, they subtract to zero, and checking their equality gives a TRUE. However, the command is not finding the given index and matching it. In fact the error given is that "Did not find value '442770.47916666666666' in MATCH evaluation. The second command is
=vlookup(TODAY()&E14,MolliesEvents,6,0) with similar definitions and it is still unable to find the given locale. Any help?
https://docs.google.com/spreadsheets/d/1JINVcTPlfjPK1SPoTDC9eKhpYzmG6daq3umrBn_8TP0/edit?usp=sharing is the link to a copy of the same google sheet so that you can work directly with the source.