You create a shape that has two Shape Data rows named Department and CostCode. Both the Department and the CostCode rows have the Type =1.

The Department row Format cell has the formula =A;B.

You need to modify the ShapeSheet to meet the following requirements:

When a user selects Department A, only CostCodes A1 and A2 are visible. When a user selects Department B, only CostCodes B1 and B2 are visible.

What should you do?

A.
Insert a new user-defined cell and enter the formula =SETF(GetRef(Prop.CostCode.Format), = INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″,”|”))

B.
Enter the following formula in the Format cell of the CostCode Shape Data row.
=INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″)

C.
Enter the following formula in the Format cell of the CostCode Shape Data row.
=””””&INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″,”|”)&””””

D.
Enter the following formula in the Format cell of the CostCode Shape Data row.
=INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″,”|”)