Hi everyone,
A silly doubt, but not getting an idea.
I have a file with list of day codes in D column and to their respective volumes for each day is mentioned in the next sheet called list.
Based on the filter I choose in E3, the respective values should pick in E8, E9, E10 etc till E27.
For example:
If I choose E3 as Monday then, my E8 to E27 should be as below based on List sheet: Hlookup is very manual to change the row index number. Any other way of doing this pls?
100
150
250
320
440
120
160
180
240
265
290
315
340
365
390
415
440
465
490
515
A silly doubt, but not getting an idea.
I have a file with list of day codes in D column and to their respective volumes for each day is mentioned in the next sheet called list.
Based on the filter I choose in E3, the respective values should pick in E8, E9, E10 etc till E27.
For example:
If I choose E3 as Monday then, my E8 to E27 should be as below based on List sheet: Hlookup is very manual to change the row index number. Any other way of doing this pls?
100
150
250
320
440
120
160
180
240
265
290
315
340
365
390
415
440
465
490
515