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 ...
In F8:H12, use the following:
=VLOOKUP($E8&$C$8,$M$7:$P$31,2,0)
You’ll need to change the 2 to 3 for column G and 4 for column H.
=VLOOKUP($E8&$C$8,$M$7:$P$31,2,0)
You’ll need to change the 2 to 3 for column G and 4 for column H.
A huge thank Michael, your suggestion worked perfectly. Thank you for your time in assisting me today. 😃👍
