VLOOKUP issue with pictures

Copper Contributor

I need help with my 3 tab spreadsheet  where 1 tab is the pictures, 'ALL' tab that has the whole dataset and the last tab is the final sheet that uses the VLOOKUP to bring the data over from the All tab to specific Item number.

The pictures in the column are formatted as locked and Move with cells

I cant seem to figure it out.

 

 

 

3 Replies
The solution to a problem like this is a function that's currently in preview for Insiders - the IMAGE function. Something to look forward to in the future.
https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5?ns=ex...
oh great to hear. I havent used Access in years beacause of how excel was easier to use to get the same job done (at least for me). Do you know if access can accomplish this?
I don't believe Access has the feature in tables but don't quote me on that because I don't use it much for the same reasons you've given. I prefer Excel.