Picture lookup??

[JZ119]

I have a drink file with a sheet 1 where there is a drink table and data tab with data. I don't know if this is possible but I need to have the pictures on the data tab looked up or someway to sheet 1. The table that is on sheet 1 needs to be able to be sorted and filtered which would mean I need the pictured to be able to change depending on what drink is there. I would also need to be able to add data to the data table and have it automatically updated on the sheet 1 table. I attached a example file of what I am trying to do. Thank you in advance for any help.




Drinks.xlsm

[NeedForExcel]

Here!

Check this out.

http://www.youtube.com/watch?v=MzF_5DXhqbs

Let me know if you still have trouble finishing the formula and Ill help you out.

Deep

[JZ119]

The video only shows how use the picture look up using data validation drop down list.

I need to be able to look up the multiple pictures in a table (from the pictures in the data tab) not just one picture. When the table gets sorted or filtered I need the pictures to do the same if that is possible.

(The drink name is in col A and the photo col H needs to be looked-up from the data tab based off the drink name in col A)