Question: m. Use various formula(s), excluding referencing, to look up respective values for CAP columns J through N. You should not use referencing for CAP figures.

m. Use various formula(s), excluding referencing, to look up respective values for CAP columns J through N. You should not use referencing for CAP figures. Instead, use formula(s) such as, If, Iferror, and vlookup to lookup values in the CAP worksheet. Preferably, use formulas that we discussed in the class. You may add columns/rows. Capture the screenshots of all of your steps for column L (Principal). Save those screenshots at the designated area on Notes worksheet
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
