Embedded objects query- Help Required!

%3CLINGO-SUB%20id%3D%22lingo-sub-818405%22%20slang%3D%22en-US%22%3EEmbedded%20objects%20query-%20Help%20Required!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-818405%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20anyone%20can%20help%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20embedded%20PDF%20files%20within%20a%20table%20but%20I%20would%20like%20to%20return%20a%20specific%20embedded%20file%20based%20on%20a%20cell%20value.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20I%20have%20an%20embedded%20PDF%20for%20Product%201%20in%20the%20table%20which%20I%20would%20like%20to%20be%20pulled%20through%20on%20a%20summary%20tab%20when%20product%201%20is%20selected%20from%20a%20data%20validation%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20it%20is%20possible%20with%20a%20vlookup%20when%20using%20hyperlinks%20to%20files%2C%20however%20unfortunately%20I%20cannot%20use%20hyperlinks%20in%20this%20scenario%20as%20this%20file%20will%20be%20going%20out%20externally.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20and%20suggestions%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELuke%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-818405%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eembedding%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eobjects%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

 

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

 

Luke

0 Replies