can I use dates as the lookup argument with HLookup?

C

crashume

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

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
 
Top