Dear AcwayGood day,
I have several tasks on Master List based on days. I would like a formula to populate an instructor from sheet1 that has the skills to perform the task
=IFNA(TEXTJOIN("/", TRUE,IF(INDEX(Sheet2!$D$2:$T$47,,MATCH('Master List'!$A3,Sheet2!$D$1:$T$1,0))<>"X",Sheet2!$B$2:$B$47,"")), "")
Disregard, I was able to change it. Thank you again for your help.Can we change it around? Can the formula pick up the employees with the X. X shows they are qualified for the task.
Dear Of course. You can easily do it by modifying the formula. All you need to do is to replace the <> sign with the = sign.Can we change it around? Can the formula pick up the employees with the X. X shows they are qualified for the task.
=IFNA(TEXTJOIN("/", TRUE,IF(INDEX(Sheet2!$D$2:$T$47,,MATCH('Master List'!$A3,Sheet2!$D$1:$T$1,0))="X",Sheet2!$B$2:$B$47,"")), "")
It is excellent you have figured it out. You are most welcome.Disregard, I was able to change it. Thank you again for your help.
Good day, I have one more to ask. On the same attachment. If you unhide the tabs, you'll see 3 more tabs. Is there a way to have the tasks & dates populate onto the Master tab and assign it to an instructor? I currently have to manually input that dataIt is excellent you have figured it out. You are most welcome.
Regards
ExcelDemy
Dear, Thanks for your patience! We have reviewed your dataset and found many data inconsistencies, so we are having difficulties coming up with an idea. Again, as the problem seems like a new one, it would be better if you create a new thread, explain the requirements in more detail, and provide consistent data that will help us test when we have finished developing formulas.Good day, I have one more to ask. On the same attachment. If you unhide the tabs, you'll see 3 more tabs. Is there a way to have the tasks & dates populate onto the Master tab and assign it to an instructor? I currently have to manually input that data