Date and HLOOKUP
 

Hi

I have a cell D1 with the formula "TODAY" so that it will automatically put today's day in when we open it. {name is INPUT).

On a different tab {name is INDUCT CALCULATIONS} I am trying to enter a HLOOKUP formula.

It will reference a completely different worksheet {2 Week Resource Plan 20.08.2013}, so that it will look up today's date [D1} across the header rows and return a value in row 3. I can do it when INPUT D1 and the header row on 2 wk resource plan are values, but can't do it when they are dates. The formula I have used is as below:

=HLOOKUP(INPUT!D1,'[2 Week Resource Plan 20.08.2013.xlsx]Resource'!$FY$1:$GC$11,3,FALSE)