Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return array of data by date range
I am trying to determine if VLOOKUP can search an array by any day within a
calendar month (look_up_value) and return a list of names in the adjacent column (table_array). Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return array of data by date range
I believe you're saying you'd like to have a list of dates in one column (A)
and a corresponding list of month names in another (B). You could set up a table of data off to the side or on another sheet which contains the list of month numbers and month names like this: Month_Num Month_Name 1 January 2 February 3 March etc etc To get the name of the month into column B, you would just VLOOKUP the month in the table like this: =VLOOKUP(MONTH(A2),$Y$1:$Z$15,2,0) This assumes the list of month names is in Y1:Z15. A better solution to this problem might be to have column B just = column A. Then format column B as the month name only by going into Format Cells - Custom and typing MMMM in the custom format box. Then, column B will ACTUALLY be the dates, but will LOOK like the month names. Does that work? -- If you like this answer, please click ''Yes.'' Happy calculating! "Ken King" wrote: I am trying to determine if VLOOKUP can search an array by any day within a calendar month (look_up_value) and return a list of names in the adjacent column (table_array). Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return an array of data based on range of date | Excel Worksheet Functions | |||
array formula: return next date from list | Excel Worksheet Functions | |||
Lookup Value in Range/Array and Return Column Header Value | Excel Discussion (Misc queries) | |||
Lookup Value in Range/Array and Return Column Header Value | Excel Worksheet Functions | |||
Can INDIRECT return a range array? | Excel Worksheet Functions |