If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can I use dates as the lookup argument with HLookup?
Syntax seems right but I get a #value result. Am i right to assume date arent
usable? |
#2
|
|||
|
|||
can I use dates as the lookup argument with HLookup?
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? |
#3
|
|||
|
|||
can I use dates as the lookup argument with HLookup?
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? |
Thread Tools | |
Display Modes | |
|
|