| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a date in a cell for "lookup_value" in HLOOKUP functi
I am using the HLOOKUP function to grab a date in an adjacent cell as the
"lookup_value" (the first argument in the syntax for the function). The date is in the format of "Sunday, January 1, 2006". I use the function to go to another worksheet, look across a row, find the date, then return back the contents of a cell below the referenced date. The problem I am having is that the HLOOKUP function sees the date as a date in sequential serial number form. When it tries to look for the date in the other worksheet, it does not find it and returns "#N/A". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi | Excel Worksheet Functions | |||
| which record is deleted when I use the "remove duplicates" functi. | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Multiple "lookup_value" | Excel Worksheet Functions | |||
Threaded Mode
