I have a list of countries in my Excel tool and each of them has their own PDF file content.

I have embedded these PDFs as objects into the Excel tool, so that users of the Excel tool can open up the PDFs within the Excel file.

In the dashboard, users can select a country from a dropdown list and I would like the corresponding PDF object to show up (i.e., the PDF files are not be displayed together, but only based on cell value).

There are solutions online to change or insert images based cell values (named range + INDEX/MATCH + linked picture).

I've tried taking the same approach for the objects, but it does not work. I'm wondering if anyone has an equivalent solution for Excel objects.

Much thanks.