Box connected to a slicer in excel

[NicoF06ppt]

Hi community,

I need help about connected a box to a slicer. I created a table with some diameter intervals. For each intervals, a number is corresponding (like 7 for diameters from 5 to 10 mm).

I created a Slicer for the diameter table, and I want when I click on a diameter interval in the slicer ; the green box "corresponding of the diameter selection" display the corresponding number.

For exemple, if I click in the slicer on "10 to 15 mm" , the green box would display "12".

Thanks for your support !

[#2]

You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral