SOLVED

Tie image to cell, based on the list selection

%3CLINGO-SUB%20id%3D%22lingo-sub-2821962%22%20slang%3D%22en-US%22%3ETie%20image%20to%20cell%2C%20based%20on%20the%20list%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2821962%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%20Excel%20Community%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20you%20can%20help%20me%20with%20my%20issue.%20I%20have%20looked%20through%20all%20the%20possible%20sources%2C%20but%20yet%20not%20found%20what%20I%20am%20looking%20for.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20a%20hobby%2C%20I%20play%20poker%20and%20knowing%20what%20to%20play%20in%20which%20position%20is%20vital.%20I%20have%20created%20numerous%20charts%20based%20on%20the%20table%20size%2Fposition%20and%20saved%20them%20as%20pictures.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I%20want%20is%20that%20firstly%2C%20from%20the%20list%20I%20select%20the%20table%20size%2C%20than%20select%20my%20position%20(from%20another%20list)%20and%20I%20want%20chart%20(picture%20from%20another%20sheet)%20to%20appear%20below.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20created%20table%20on%20'charts'%20sheet%20and%20uploaded%20pictures%20to%20fit%20the%20cell%20for%20the%20first%20two%20tables.%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20you%20know%20how%20to%20help%20me%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2821962%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2832987%22%20slang%3D%22en-US%22%3ERe%3A%20Tie%20image%20to%20cell%2C%20based%20on%20the%20list%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1178392%22%20target%3D%22_blank%22%3E%40Voldie%3C%2FA%3E%2C%26nbsp%3Btry%20the%20attachment%20with%20a%20defined%20name%20to%20reference%20an%20image%20to%20a%20cell%3A%26nbsp%3B%3CSTRONG%3EMyChart%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DINDIRECT(%22'Charts%20'!%22%20%26amp%3B%20ADDRESS(MATCH('Table%20charts'!%24B%245%2C'Charts%20'!%24A%3A%24A%2C0)%2CMATCH('Table%20charts'!%24A%245%2C'Charts%20'!%241%3A%241%2C0)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EPedro%20Wave%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning Excel Community,

I hope you can help me with my issue. I have looked through all the possible sources, but yet not found what I am looking for. 

As a hobby, I play poker and knowing what to play in which position is vital. I have created numerous charts based on the table size/position and saved them as pictures. 

What I want is that firstly, from the list I select the table size, than select my position (from another list) and I want chart (picture from another sheet) to appear below. 

I have created table on 'charts' sheet and uploaded pictures to fit the cell for the first two tables.

Would you know how to help me? 

Thank you in advance. 

2 Replies
best response confirmed by Voldie (New Contributor)
Solution

@Voldie, try the attachment with a defined name to reference an image to a cell: MyChart

 

=INDIRECT("'Charts '!" & ADDRESS(MATCH('Table charts'!$B$5,'Charts '!$A:$A,0),MATCH('Table charts'!$A$5,'Charts '!$1:$1,0)))

 

Regards,

Pedro Wave

 

 

Wow, that works perfectly, thank you a lot! Does not look that easy.