An If Function That's Too Complicated For Me

First, get % of Quarter 1: current/Quota: I3/INDEX($B$3:$E$3,MATCH(I2,$B$2:$E$2,0))

Below formulas are getting Factor in J3 then copy to M,P,S column:

With IF:

Please Login or Register  to view this content.

Or with LOOKUP much shorter:

Please Login or Register  to view this content.

Originally Posted by oliverhj

I'm looking for the If function in J3-6, M3-6, P3-6 and S36.[/ATTACH]

If you are looking for the appropriate factor, shouldn't you be looking to populate the K3 cell? If that's the case, you could use this:

Please Login or Register  to view this content.

But this is not dynamic, since there are a few formatting problems that would stand in the way of creating a simple lookup formula (merged cells, factor values in between percentage values).

If I assumed incorrectly, can you please show what you expect your results to look like?

Originally Posted by oliverhj

I'm looking for the If function in J3-6, M3-6, P3-6 and S36.[/ATTACH]

If you are looking for the appropriate factor, shouldn't you be looking to populate the K3 cell? If that's the case, you could use this:

Please Login or Register  to view this content.

But this is not dynamic, since there are a few formatting problems that would stand in the way of creating a simple lookup formula (merged cells, factor values in between percentage values).

If I assumed incorrectly, can you please show what you expect your results to look like?