Forum Discussion
VLOOKUP issue with pictures
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.
5 Replies
its a few years now, and I am still having this issue. I have a 1200 pictures in separate cells that I want to "Place in cell" so I can reference from a separate spreadsheet. I can use vlookup or IMAGE function?
Besides spending an hour or more hitting each picture to "place in cell" is there a way to "Place in cell" in once action or formula?
You can use a macro to loop through the objects in the sheet:
Sub PlaceAllPicturesInCells() Dim s As Shape Application.ScreenUpdating = False 'Go through all pictures in sheet and place in cells For Each s In ActiveSheet.Shapes s.Select s.PlacePictureInCell Next s Application.ScreenUpdating = True End SubI'm not a vba guy so this looks rudimentary but gets the job done.
- 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=excel&version=90&ui=en-us&rs=en-us&ad=us- 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.
