I am trying to find a way to automate a procedure for a client review at work. 

I would have a cell that contains the clients attitude to investment risk – e.g. “Cautious”, “Balanced” or “Adventurous”.

Depending which of the 3 options is selected, I would like a cell next to it to pre-populate with a picture/icon that contains the numbers “3”, “4” or “5”. In this case – Cautious = 4, Balanced = 5 and Adventurous = 6. 

Would anyone be able to advise please?

​I am trying to find a way to automate a procedure for a client review at work.  I would have a cell that contains the clients attitude to investment risk – e.g. “Cautious”, “Balanced” or “Adventurous”. Depending which of the 3 options is selected, I would like a cell next to it to pre-populate with a picture/icon that contains the numbers “3”, “4” or “5”. In this case – Cautious = 4, Balanced = 5 and Adventurous = 6.  Would anyone be able to advise please?  Read More

​