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.
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.
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.
To use a multi-valued lookup column, follow this procedure:
The selected choices appear in the cell, separated by semicolons (;).