I want to get a formula to get the data based on sheet name, ideally if and lookup together.
Exactly what i am looking for is in the attached sheet, C3 = (if C1=Week 1, should go to Week 1 sheet and find the value of ETC for Item code B3)
please help
Bookmarks