I want to display a column of values from one sheet based on a date I select on another sheet.
Changing the date I select will display a different column of values.
Sheet containing the values I want to display:
Sheet I want to display on:
The table immediately above is only meant to demonstrate the outcome of values when choosing just one date; I don't want to have three menus to choose three dates.
I tried INDEX/MATCH, but was unsuccessful as I eventually realized that would only produce one value, not all of the values I wanted to display.
I thought if I could somehow identify the appropriate column, I could then reference something like D3#, for example, which would take care of the SPILL.
Anyone have an idea for a solution?
Changing the date I select will display a different column of values.
Sheet containing the values I want to display:
| A | B | C | D | E | description |
|---|---|---|---|---|---|
| 2 | 4 | 1 | 4 | 3 | count of values in each column (minus this row and the one immediately below); I thought this might be helpful in knowing how many rows I'd need to display on the sheet below |
| 5/29/22 | 6/5/22 | 6/12/22 | 6/19/22 | 6/26/22 | simple dates |
| Donald | Timothy | George | Ringo | David | actual values I want to display; this row is the beginning of a SPILL formula |
| Mark | Dan | Linda | Susan | ||
| Stuart | Bob | Lisa | |||
| Burt | Peggy |
Sheet I want to display on:
| A | B |
|---|---|
| [this is a pull-down menu containing the dates in row 2 above] | These are the results based on the selected date on the left: |
| Selection = 6/19/22 | Ringo |
| Linda | |
| Bob | |
| Peggy | |
| Selection = 6/12/22 | George |
| Selection = 6/5/22 | Timothy |
| Dan | |
| Stuart | |
| Burt |
The table immediately above is only meant to demonstrate the outcome of values when choosing just one date; I don't want to have three menus to choose three dates.
I tried INDEX/MATCH, but was unsuccessful as I eventually realized that would only produce one value, not all of the values I wanted to display.
I thought if I could somehow identify the appropriate column, I could then reference something like D3#, for example, which would take care of the SPILL.
Anyone have an idea for a solution?
