Tried searching the forum, but I didn't find the exact answer to my question..
I have a large number of SKU's (200+) with their individual images in the next cell, on the sheet #2 of a workbook.
e.g.
cell A1 text "apple", cell B1 "apple.jpg"
cell A2 text "banana", cell B2 "banana.jpg"
... etc
On sheet #1 , I draw a list containing some of those SKU's (one week's sales report in this case).
What I need, is the image to appear next to the SKU on the second sheet once I enter a SKU name in the cell.
Not in the same order necessarily as the source images.
I've only found a way to create a dropdown menu into one cell, which then finds the image for one of the items in the menu.
However in this case I need the image lookup to happen in multiple cells at once, and for the dropdown option I would apparently have to create the whole thing individually for each target cell.
Since I need this for a weekly sales report, copying and pasting the individual images each time takes up a lot of time since I have a lot of SKU's to deal with.
If possible, I am looking for a non macro way to so this (don't really know how to use them..)
Ali Enthusiastic self-taught user of MS Excel who's always learning! Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
Bookmarks