VLOOK to return an image

Hi

I am wondering if there is a way of using a VLOOK (or other function) to return an image based on the data in an adjacent cell.

To help explain i have atatched a spreadsheet.

The desired result for this would be that the formula in cell F2 would return the Everton crest.

logos.xlsx

Is this sort of query possible?

thanks Fotis... i will look at this when i get home later

hi... ive tried this.... but it doesnt seem to be what im after.

i need to get the result from a lookup if possible... it doesnt work for me having a drop down... I was looking at having this over 200 times in a worksheet

I have found a help guide thats seems to explain how to do it

http://www.excelguru.ca/content.php?...P-for-Pictures

However, when i get to the following bit, i cant get the picture to display the name... i have tried recreating the steps in the explanation over 20 times now and each time it doesnt work.. as you can see from the xl file, the pictures carry 'picture 1, picture 2 etc instead of the team name.

swswswswsw.jpg

Book1111.xlsx

does anyone know what im doing wrong?

is there a missing step in the explanation?