If - Index Match Issue

[jamesmev]

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 of PasteMDMCoverage then use F
otherswise use E for the index match...

I can't figure this one out.. Maybe over thinking it?

 

[Special-K99]

Just have a normal INDEX( range. MATCH() )

and expand the INDEX range to columns E:F and adjust the column number to retrieve, so where you name the column number reaplce it with an IF condition if(E2="", 2, 1), ie If E2 is blank extract column 2 (extracting column F, otherwise column1 (column E)