Question

The spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer’s Agent, Dual Agent, Seller’s Agent). You want to switch the codes for the actual descriptions.
In cell E12 of the Details sheet, insert the SWITCH function to evaluate the agent code in cell D12. Include mixed cell references to the codes and roles in the range J2:K4 for the values
and results arguments. use all cell references in the function. Copy the function to the range E13:E39.

Answer 1

Solution

Step 1

Go to cell E12

Step 2

Write the following formula

=SWITCH(D12,$J$7,$K$7,$J$8,$K$8,$J$9,$K$9)

enter

Step 3

now copy the formulla from E13:E39

Step 4

---

all the best