Add a multi-valued lookup column

You can use a multi-valued lookup column to select more than one item from the list of choices at a time. For example, in a task-tracking list, you can assign more than one person to each task. The values in the lookup column come from an existing column in the current list, or from an existing column in another list.

Add a multi-valued lookup column

1. Right-click any column heading or any cell in the list, and then click Add Column.

2. Under Name and Type, enter a name for the column, and then click Lookup (information already on this site).

3. Under Additional Column Settings, select the list that contains the values you want in your lookup column from the Get information from drop-down list.

4. Select the column that contains the values from the In this column drop-down list.

5. Select Allow multiple values.

6. Set any other options you want, and then click OK.

To use a multi-valued lookup column while viewing the datasheet, click the drop-down arrow in the cell, and then select or clear the check box next to each value that you want to add or remove from the cell.

Edit the list of choices in a multi-valued lookup column

Because the items in a multi-valued lookup column come from another column in the current list or from a column in another list, you must edit the list on which the lookup column is based. For example, if the lookup column is based on the Title column of the Tasks list, you must edit the Tasks list to change the values in the lookup column.

Use a multi-valued lookup column

To use a multi-valued lookup column, follow this procedure:

1. Click the drop-down arrow in the cell you want to edit.

2. Select or clear the check box next to each item that you want to add or remove from the cell.

3. Click OK.

The selected choices appear in the cell, separated by semicolons (;).