I want the recipient cell (I6) to equal the following statement: "Cable Median Barrier Repair" if the value posted to cell E10 on a worksheet identified as CANDIDATE SELECTION is "C". If however, the value posted to cell E10 is "R", then the recipient cell (I6) is to reflect the following...