Forum Discussion

Voldie's avatar
Voldie
Copper Contributor
Oct 07, 2021
Solved

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

  • PedroWave's avatar
    PedroWave
    Brass Contributor

    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

     

     

    • Voldie's avatar
      Voldie
      Copper Contributor
      Wow, that works perfectly, thank you a lot! 🙂 Does not look that easy.