Tie image to cell, based on the list selection

[Voldie]

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 · Accepted 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

[#3]

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