Description

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.


  1. Watch the Sample box as you build a format.
    Figure 7-69 Custom format for values<

  2. The formula is =VLOOKUP(C3,Data!$A$2:$D$10,4)
    Figure 7-70 VLOOKUP formula

  3. The date must be today or earlier.
    Figure 7-71 Data validation for dates

  4. Options depend on the type of control.
    Figure 7-72 Combo box settings
  5. Select cell D4 and use CONCAT and INDEX to display the result from the combo box, concatenating the Indexresults to the word “Quarter.”

    1. The link cell (F8) displays its contents in the combo box control.
      Figure 7-73 INDEX is nested within CONCAT

    2. The space is before the word Quarter and after the result from the INDEX function.
      Figure 7-74 Space character is included with Text2 argument
Completed worksheet for Excel 7-6
Figure 7-75 Completed worksheet for Excel 7-6