I'm trying to get the
HLOOKUP function working in my sheet but it's not working like it should.
The function is:
=HLOOKUP(TEXT(NOW(), "yyyy-MM-dd"), INDIRECT(TEXT(NOW(), "MMMM") & "!B1:AE5"), 3, FALSE)
Translating the functions, that would be:
=HLOOKUP("2015-07-01", July!B1:AE5, 3, FALSE)
I get an error however:
Did not find value '2015-07-01' in HLOOKUP evaluation
That doesn't make sense since
'2015-07-01' is in cell B1 in the sheet, July.
Why isn't it working and what can I do to fix it?