Can anyone help me please with the attached excel sheet
1. Explaining why the formula =IFERROR(INDEX(tblData,MATCH(C$5+$B9&ShowName,tblData[DATE & TIME]&tblData[WHO],0),3),"") is not pulling the correct data from the data entry sheet in the attached spread sheet, when I press enter the result disappears.
2. Is it possible to have an option to see the tasks for everyone on the weekly planner on the drop down list?
Cheers
Bookmarks