Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
can I use dates as the lookup argument with HLookup?
3 views
Skip to first unread message
crashume
Nov 11, 2009, 11:12:01 PM11/11/09
to
Syntax seems right but I get a #value result. Am i right to assume date arent
usable?
usable?
Jacob Skaria
Nov 11, 2009, 11:21:01 PM11/11/09
to
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
T. Valko
Nov 11, 2009, 11:25:06 PM11/11/09
to
You can use dates as a lookup_value.
Post the formula you're trying to use.
--
Biff
Microsoft Excel MVP
"crashume" <cras...@discussions.microsoft.com> wrote in message
news:5BC878B7-6C70-4A72...@microsoft.com...
0 new messages