Dynamic Pictures based one someones name

[Novicesportsperformer]

Hi all,

Wondering if you could help me here.

I am trying to create some profiles for some players in which I change the name and their picture changes.

I have created a table with their picture next to their name and followed some instructions online to make dynamic pictures however I keep getting an error saying reference isnt valid.

I think its because the when doing the defined names --> create from selection, when using two words excel puts in an "_" ie John Doe because John_Doe.

However, im not sure...

Can anyone help me please?

Thank you!

 

[stumac]

Try using substitute to replace spaces:

=INDIRECT(SUBSTITUTE([I][COLOR=#0000ff]A1[/COLOR][/I]," ","_"))

 

[Novicesportsperformer]

Brilliant,

Thank you very much!