Associating a cell with a picture

[Vasco39]

[TABLE="width: 0"]
<tbody>[TR]
[TD="colspan: 7"]I have an Excel sheet that calculates the positions of each country in a Group after placing the scores of each match for the 2018 World Soccer Cup in Russia. I have national flags corresponding to each country shown on the top of the 1^st rectangle in the example and on column AC. The positions of these flags are fixed. In the example they are Pictures. The sheet can choose a language out of 5. The example shown is in English. The top rectangle shows the Excel sheet I have done. The position of the countries shown on the rectangles on the left change automatically depending on the scores of the matches.

What I want is what is shown on the 2nd rectangle. What I want is that the flags of each country shown on column E correspond to the country on its left as shown in the example (independently of the language chosen). Columns AB and AC are fixed except that the name of the countries will be written in the language we have chosen.

Is this possible? Associate a cell with a picture or concatenate a cell and a picture.
The countries shown on column D have a formula that makes them changing position as well as the language
Does it help if I attach the corresponding excel sheet in this forum?
Thanking you in advance Vasco39



[TABLE="width: 0"]
<tbody>[TR]
[TD="colspan: 7"]Choose Idioma / Language / Idiome >>>>
[/TD]
[TD="colspan: 5"]English - Inglês
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]AA
[/TD]
[TD]AB
[/TD]
[TD]AC
[/TD]
[/TR]
[TR]
[TD="colspan: 7"]Results as I have on my spreadsheet
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Groups
[/TD]
[TD]List of countries
[/TD]
[TD]Flags
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]D
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]Country 1
[/TD]
[TD]Flag1
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Group A
[/TD]
[TD]Flag1
[/TD]
[TD]
[/TD]
[TD]Flag2
[/TD]
[TD]
[/TD]
[TD]Flag3
[/TD]
[TD]
[/TD]
[TD]Flag4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]Country2
[/TD]
[TD]Flag2
[/TD]
[/TR]
[TR]
[TD]Pl
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]GD
[/TD]
[TD]Pts
[/TD]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]Country 3
[/TD]
[TD]Flag3
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Country 4
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]8
[/TD]
[TD]3
[/TD]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]Country 4
[/TD]
[TD]Flag4
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Country 1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]7
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]B
[/TD]
[TD]Country 5
[/TD]
[TD]Flag5
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Country 2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]B
[/TD]
[TD]Country 6
[/TD]
[TD]Flag6
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Country 3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD]-3
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD]B
[/TD]
[TD]Country 7
[/TD]
[TD]Flag7
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]B
[/TD]
[TD]Country 8
[/TD]
[TD]Flag8
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C
[/TD]
[TD]Country 9
[/TD]
[TD]Flag9
[/TD]
[/TR]
[TR]
[TD="colspan: 7"]Results as I want on my spreadsheet
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C
[/TD]
[TD]Country 10
[/TD]
[TD]Flag10
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C
[/TD]
[TD]Country 11
[/TD]
[TD]Flag11
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Group A
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD]C
[/TD]
[TD]Country 12
[/TD]
[TD]Flag12
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Pl
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]GD
[/TD]
[TD]Pts
[/TD]
[TD][/TD]
[TD]D
[/TD]
[TD]Country 13
[/TD]
[TD]Flag13
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Country 4
[/TD]
[TD]Flag4
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]8
[/TD]
[TD]3
[/TD]
[TD]6
[/TD]
[TD][/TD]
[TD]D
[/TD]
[TD]Country 14
[/TD]
[TD]Flag14
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Country 1
[/TD]
[TD]Flag1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]7
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD]etc..
[/TD]
[TD]etc..
[/TD]
[TD]etc..
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Country 2
[/TD]
[TD]Flag2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD]down to Group H
[/TD]
[TD]down to Country 32
[/TD]
[TD]down to flag 32
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Country 3
[/TD]
[TD]Flag3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD]-3
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD="colspan: 5"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

I am not really clear about your objective. But I can offer this link, which allowed me to create a method of associating NHL team logos with cells in the spreadsheet. Let us know if it helps.

https://trumpexcel.com/picture-lookup-in-excel-using-named-ranges/

 

[Vasco39]

Thank you very much DRSteele for your time.
This is nearly what I want. This works for placing a flag (in this case a Club Logo) in one cell only. But I have a list of 32 countries where I have to place on the right the corresponding flag. Since I'm not an expert in Excel I haven't yet find how to do it. I think I will manage to find the solution but I will let you know no matter what will the outcome be.
Thank you again

 

[Vasco39]

In addition to what I said before those 32 countries do not have a fixed position. They are placed according to the the scores obtained between the countries.
Thank you again

 

[DRSteele]

I'm still not clear. Those instructions demonstrate how to have a picture displayed based on the contents of a cell. For example, I have a Data Validation cell that lists all 31 NHL teams; when I select one of the teams from the drop-down list, Excel displays the corresponding logo in the cell next to it. Isn't that what you seek? To have the appropriate flag appear next to a cell, whose contents may vary?

 

[Vasco39]

I want to have something like this.
On the right I have 2 columns E and F with all the countries and respective flags. This will never change.
On the left after placing the scores of the matches, positions of Countries in column A will vary therefore the corresponding flags on column B will vary too.

[TABLE="width: 0"]
<tbody>[TR]
[TD="colspan: 2"]List and positions of all countries that will vary depending on the scores of the matches
[/TD]
[TD][/TD]
[TD="colspan: 2"]Fixed list of all countries and respective flags
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD][/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Group A
[/TD]
[TD][/TD]
[TD]Country 1
[/TD]
[TD]Flag 1
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 2
[/TD]
[TD]Flag 2
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 3
[/TD]
[TD]Flag 3
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 4
[/TD]
[TD]Flag 4
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 5
[/TD]
[TD]Flag 5
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Country 6
[/TD]
[TD]Flag 6
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Group B
[/TD]
[TD][/TD]
[TD]Country 7
[/TD]
[TD]Flag 7
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 8
[/TD]
[TD]Flag 8
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 9
[/TD]
[TD]Flag 9
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 10
[/TD]
[TD]Flag 10
[/TD]
[/TR]
[TR]
[TD]Country ?
[/TD]
[TD]Corresponding Flag ?
[/TD]
[TD][/TD]
[TD]Country 11
[/TD]
[TD]Flag 11
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Group C down to Group H
[/TD]
[TD][/TD]
[TD="colspan: 2"]down to 32 countries
[/TD]
[/TR]
[TR]
[TD]etc
[/TD]
[TD]etc
[/TD]
[TD][/TD]
[TD]etc
[/TD]
[TD]etc
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Vasco39]

DrSteele
Just to let you know that I solved the situation.
I used the INDIRECT function and it works perfectly.
Thanks in any case for your help

 

[DRSteele]

You're welcome.​

I'm glad you solved it!

 

[PALANI]

Please Let me know how it works INDIRECT function. I have the same problem.

 

[Macropod]

Palani: It appears you're asking about the same issue in: https://www.mrexcel.com/forum/excel...ing-cell-picture-post5076405.html#post5076405

Please read Mr Excel's policy on posting duplicate questions in rule 12: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html