Forum Discussion
To IF or to INDEX or to VLOOKUP, that is the question?
Hello Folk's, I want to create a simple spreadsheet that returns start and end times based on a week number. For example, I have a five week cycle period Week 1 to Week 5, Monday to Friday with ...
DickScrongle , you don't need helper column here. Use INDEX/MATCH with criteria like
=INDEX(N$6:N$25,MATCH(1,INDEX(($K$6:$K$25=$C$8)*($L$6:$L$25=$E8),0),0))
in F8, drag to the right and down
Hello Sergei, with a little tweak this also worked really well. Interesting that yours and @MichaelMays suggestion worked really well but using different formulas. Thank you for your time today Sergei, I really appreciate it. 😃👍
You are welcome. In Excel everything could be done by few several ways. Select one which you better understand, thus it'll be easier in maintenance. And try other approaches, perhaps you find them more suitable.