I've been trying to figure out the best way to get data based on a current date and typically use vlookup but it won't allow 12 conditional statements to look at each month. I want to populate based on the current date retrieving from tables from each month assuming the table was extended out all the way to December in the same format.
<tbody>
</tbody>
So if it was 1/18/19 I would want to select all values in each department for the month of Jan...or if it was 11/15/19 I would want to select all values in each department for November and fill the table below with that data:
January
Dep 1 55 12 46 79
Dep 2 12 56 89 32
Dep 3 13 46 79 98
Dep 4 25 58 36 69
Dep 5 66 55 88 31
Thanks for any help getting past the nested if limitations with this!
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
Jan | Jan | Jan | Jan | Feb | Feb | Feb | Feb | Mar | Mar | Mar | Mar | Apr | Apr | Apr | Apr | May | May | May | May | Jun | Jun | Jun | Jun | Jul | Jul | .... | |
Wk1 | Wk2 | Wk3 | Wk4 | Wk1 | Wk2 | Wk3 | Wk4 | Wk1 | Wk2 | Wk3 | Wk4 | Wk1 | Wk2 | Wk3 | Wk4 | Wk1 | Wk2 | Wk3 | Wk4 | Wk1 | Wk2 | Wk3 | Wk4 | Wk1 | Wk2 | ... | |
Dep 1 | 55 | 12 | 46 | 79 | 89 | 56 | 23 | 12 | 02 | 15 | 48 | 78 | 45 | 56 | 89 | 23 | 56 | 89 | 56 | 12 | 54 | 87 | 35 | 68 | 48 | 48 | ... |
Dep 2 | 12 | 56 | 89 | 32 | 54 | 87 | 97 | 64 | 31 | 65 | 32 | 02 | 15 | 59 | 48 | 78 | 55 | 44 | 11 | 22 | 23 | 56 | 89 | 89 | 54 | 87 | ... |
Dep 3 | 13 | 46 | 79 | 98 | 65 | 32 | 21 | 54 | 87 | 97 | 64 | 31 | 30 | 62 | 95 | 84 | 15 | 48 | 59 | 26 | 03 | 15 | 45 | 78 | 97 | 22 | ... |
Dep 4 | 25 | 58 | 36 | 69 | 47 | 14 | 25 | 48 | 15 | 25 | 36 | 65 | 98 | 32 | 12 | 45 | 65 | 78 | 98 | 85 | 25 | 41 | 36 | 75 | 53 | 12 | ... |
Dep 5 | 66 | 55 | 88 | 31 | 64 | 97 | 56 | 89 | 23 | 15 | 59 | 26 | 48 | 97 | 64 | 31 | 13 | 46 | 79 | 82 | 46 | 58 | 57 | 54 | 51 | 52 | ... |
<tbody>
</tbody>
So if it was 1/18/19 I would want to select all values in each department for the month of Jan...or if it was 11/15/19 I would want to select all values in each department for November and fill the table below with that data:
January
Dep 1 55 12 46 79
Dep 2 12 56 89 32
Dep 3 13 46 79 98
Dep 4 25 58 36 69
Dep 5 66 55 88 31
Thanks for any help getting past the nested if limitations with this!
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
Jan | Jan | Jan | Jan |
<tbody>
</tbody>