Associating a cell with a picture

Vasco39

New Member
Joined
Jan 20, 2016
Messages
10
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 1st 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



Choose Idioma / Language / Idiome >>>>
English - Inglês
AA
AB
AC
Results as I have on my spreadsheet
Groups
List of countries
Flags
C
D
A
Country 1
Flag1
Group A
Flag1

Flag2

Flag3

Flag4
A
Country2
Flag2
Pl
W
L
F
A
GD
Pts
A
Country 3
Flag3
1
Country 4
3
2
1
0
8
3
6
A
Country 4
Flag4
2
Country 1
3
1
1
1
7
0
4
B
Country 5
Flag5
3
Country 2
3
1
1
1
4
0
4
B
Country 6
Flag6
4
Country 3
3
0
1
2
5
-3
2
B
Country 7
Flag7
B
Country 8
Flag8
C
Country 9
Flag9
Results as I want on my spreadsheet
C
Country 10
Flag10
C
D
E
C
Country 11
Flag11
Group A








C
Country 12
Flag12

Pl
W
L
F
A
GD
Pts
D
Country 13
Flag13
1
Country 4
Flag4
3
2
1
0
8
3
6
D
Country 14
Flag14
2
Country 1
Flag1
3
1
1
1
7
0
4
etc..
etc..
etc..
3
Country 2
Flag2
3
1
1
1
4
0
4
down to Group H
down to Country 32
down to flag 32
4
Country 3
Flag3
3
0
1
2
5
-3
2

<tbody>
</tbody>


<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Vasco39

New Member
Joined
Jan 20, 2016
Messages
10
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

New Member
Joined
Jan 20, 2016
Messages
10
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

Well-known Member
Joined
Mar 31, 2015
Messages
2,238
Office Version
365
Platform
Windows
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

New Member
Joined
Jan 20, 2016
Messages
10
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.

List and positions of all countries that will vary depending on the scores of the matches
Fixed list of all countries and respective flags
A
B
E
F
Group A
Country 1
Flag 1
Country ?
Corresponding Flag ?
Country 2
Flag 2
Country ?
Corresponding Flag ?
Country 3
Flag 3
Country ?
Corresponding Flag ?
Country 4
Flag 4
Country ?
Corresponding Flag ?
Country 5
Flag 5
Country 6
Flag 6
Group B
Country 7
Flag 7
Country ?
Corresponding Flag ?
Country 8
Flag 8
Country ?
Corresponding Flag ?
Country 9
Flag 9
Country ?
Corresponding Flag ?
Country 10
Flag 10
Country ?
Corresponding Flag ?
Country 11
Flag 11
Group C down to Group H
down to 32 countries
etc
etc
etc
etc

<tbody>
</tbody>
 

Vasco39

New Member
Joined
Jan 20, 2016
Messages
10
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

Well-known Member
Joined
Mar 31, 2015
Messages
2,238
Office Version
365
Platform
Windows
You're welcome.
I'm glad you solved it!
 

PALANI

New Member
Joined
May 27, 2018
Messages
2
Please Let me know how it works INDIRECT function. I have the same problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,803
Messages
5,470,872
Members
406,733
Latest member
darzu

This Week's Hot Topics

Top