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 knowin...
Charting
excel
Formulas and Functions
  • PedroWave's avatar
    PedroWave
    Oct 11, 2021

    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

     

     

PedroWave's avatar
PedroWave
Brass Contributor
Oct 11, 2021

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
    Oct 11, 2021
    Wow, that works perfectly, thank you a lot! 🙂 Does not look that easy.