I am trying to solve an issue.
=ifs(PasteMDMCoverage!E2="",Index(PasteMDMCoverage!F:F,match('Workforce Template'!E2,PasteMDMCoverage!B:B,false),01),if(PasteMDMCoverage!E2>0,Index(PasteMDMCoverage!E:E,match('Workforce Template'!E2,PasteMDMCoverage!B:B,false),01))
if there is no number in E...