'Options' clause (no_values) is not working (

[Evgeny S.]

Hello, everybody!
I've a question about "options no_values" clause. Could you help me? I have 2 very large tables with several thousands of rows and only 2 columns each. First column is 'datetime' and the second is some parameter.

Example of my table - https://docs.google.com/spreadsheets/d/14KjSFWQPdNLChT76xIc8fYm5NSn8OpARoLONdmauf-c/edit?usp=sharing

In the table A datetime had been recorded each 5 minutes, and in table B – each 20 minutes. I want to merge these tables into one with datetime every 1 hour. Something like this:
Datetime (YYYY-MM-DD HH:00:00) AVG(ParameterA) AVG(ParameterB)

So what’s am I doing?
1. Getting data from table A with query:

Select MIN(A), AVG(C), Year(A), Month(A)+1, Day(A), Hour(A)
 group by Year(A), Month(A)+1, Day(A), Hour(A) Order by MIN(A)
 Format MIN(A) 'YYYY.MM.DD HH:00:00'

2. It's give me exactly that I need! Every row have been grouped by hour and everything seems to be ok.
3. Than I’m getting data from Table B with the pretty much the same query.
4. And after all I’m trying to merge data by VLOOKUP (hour-by-hour).
5. And here comes the problem! Although my datatime columns looks very nice and clean (because of format) it has different Min(A) values, because data was written in different minutes of hour.
So I have cells in Tables A&B looks like “2017.06.15 01:00:00”, but if I’m checking the values of these cells, it is “2017.06.15 01:04:00” and “2017.06.15 01:09:00” for tables A and B. And because the values is different, VLOOKUP is not working. (
6. I’ve found information about “options no_values” clause, but it is not changing anything in my case… What I’m doing wrong?

Thank you!