Xlookup variable to search for defined by slicer

I have a data table set up with a bing maps connected to display various locations around the USA. To the right of the map is a slicer allowing you to select a company name... based on that, the map isolates the address of the selection. So far, everything works fine.

But what I want to be able to do is display other values from the data table, based on the slicer selection.

I noticed in the slicer options, it gives you a name to "use in formulas" so I set my xlookup to:

Please Login or Register  to view this content.

But the lookup formula returns #N/A

I've read around Google a bit - and everyone keeps saying "Use a pivot table!" -- but if I format my data into a pivot table, I don't know how to use that pivot to create the map... it seems as though the map has to come from the data table, and the slicer has to link to a pivot table... but then the two aren't sync'd up and the slicer won't be used by the formula to return the additional data. (Dang, I hope that made sense...)

I've tried attaching a workbook, but every time I hit "upload file" the forum tells me that "the upload failed". It does not give me a reason "Why"... it is a basic xlsx workbook?




EDIT TO ADD:

I was able to upload other workbooks just fine -- my assumption is that it wont' allow me to upload it because it has a "Bing Map" in the workbook? That's the only variable that seems different to me? But if I remove the bing map, i'm not really providing an example...any ideas?

OK, try this function. Mind you, it will only return the first selected value of a slicer. If multiple values are selected in the slicer, subsequent values will be ignored.

Please Login or Register  to view this content.

For example, I have a slicer called "Sales Person" however I have to use "Slicer_Sales_Person" as the string to feed to the function. What you see as the slicer name in slicer settings isn't exactly what you need to use in VBA. Prefix it with "Slicer_" and put underscores in places of spaces.

Here is an expanded version of the above. It returns a comma separated list of slicer selections If you only have one value selected, the results will be the same as above

Please Login or Register  to view this content.