I'm wondering if anyone can help me.
I have a list of embedded PDF files within a table but I would like to return a specific embedded file based on a cell value.
For example I have an embedded PDF for Product 1 in the table which I would like to be pulled through on a summary tab when product 1 is selected from a data validation list.
Is this possible?
I know it is possible with a vlookup when using hyperlinks to files, however unfortunately I cannot use hyperlinks in this scenario as this file will be going out externally.
Any help and suggestions would be appreciated.
thanks in advance