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

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
---------------
Jacob Skaria


"crashume" wrote:

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

You can use dates as a lookup_value.

Post the formula you're trying to use.

--
Biff
Microsoft Excel MVP


"crashume" wrote in message
...
Syntax seems right but I get a #value result. Am i right to assume date
arent
usable?