Hi,
I have an AFL Football database,

The problem I have is, I want say cell A1 to display an image (the logo of the team of the chosen player) and if I choose a player from a different team (different logo), cell A1 will change to reflect that players team.

This is what the end result should look like

A1, B1, C1
Logo, Players name, Team logo name

Below is a sample
A1, B1, C1
GWS logo, Callam Ward, GWS

Note:- cell C1 has a formula to lookup the player chosen (from another place within the spreadsheet),and choose the team next to his name, in this case Callam Wards team is GWS.

I'm not sure if this can be done - getting an image from a cell that has a formula in it!

I hope I have explained it well enough as I can' attach the database (Too big)

I look forward to any replies

Mike