Excel Range Slicers/Version 6.5

The screenshot below shows a selection list containing five countries, each with its corresponding country code. When the user selects a country, its corresponding country code should be displayed.

This can be done through an XLCubed slicer. Create a slicer as follows:

• Under Selection tab, set Slicer range to =$A$1:$B$5 (this is the range of cells where the country code and country name are held).

• Under Settings tab, check Update range with selection, select Unique Name and enter cell location where you want the country code to be displayed. In our example it is B11.

When the user clicks on a slicer option, in this case France, its corresponding country code is displayed in cell B11.