can I use dates as the lookup argument with HLookup?

[crashume]

Syntax seems right but I get a #value result. Am i right to assume date arent
usable?

 

[Jacob Skaria]

With dates in excel date format along A:J1; try the below formula

'The below will match the current date and return data from second row of
the array A1:J10
=HLOOKUP(DATE(2009,11,12),A1:J10,2,0)

'lookup current date
=HLOOKUP(TODAY(),A1:J10,2,0)

'or with date in cell K1
=HLOOKUP(K1,A1:J10,2,0)


If this post helps click Yes

 

[T. Valko]

You can use dates as a lookup_value.

Post the formula you're trying to use.