Forum Discussion
Tie image to cell, based on the list selection
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.
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
2 Replies
- VoldieCopper ContributorWow, that works perfectly, thank you a lot! 🙂 Does not look that easy.