+ Reply to Thread
Results 1 to 3 of 3

multi-image lookup

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    multi-image lookup


    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 call, on the sheet #1 of a workbook.
    A1 "apple", B1 "apple.jpg"
    A2 "banana", B2 "banana.jpg"
    ... etc

    On sheet #2 , I draw a list of 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.

    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.

    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..)

    thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    Indiana, USA
    MS-Off Ver
    365 Pro Plus

    Re: multi-image lookup

    Please Login or Register  to view this content.
    Copy this code to the worksheet's code module

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    Pole in Yorkshire, UK
    MS-Off Ver

    Re: multi-image lookup

    What if I change my mind? I've got second picture covered 1st.
    (sorry for some reason I can't paste picture).

    For this cases I've added check, if any picture is already there. If yes, delete.
    Please Login or Register  to view this content.
    Last edited by KOKOSEK; 12-02-2020 at 10:26 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to lookup an image
    By amartino44 in forum Excel General
    Replies: 0
    Last Post: 10-08-2020, 08:04 PM
  2. Multi criteria lookup with the ''=lookup' formula
    By Ronnet2 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-17-2015, 07:12 AM
  3. [SOLVED] Data Validation, Lookup, multi lookup, referancing and other.
    By archasem in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-04-2013, 10:50 AM
  4. [SOLVED] multi drop down list with multi-lookup
    By civileng12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2012, 06:50 PM
  5. Multi-lookup
    By swanseaexcel in forum Excel General
    Replies: 4
    Last Post: 10-27-2010, 07:56 AM
  6. Lookup multi columns w/ multi answers
    By dec671 in forum Excel General
    Replies: 1
    Last Post: 01-28-2010, 04:48 PM
  7. Image Lookup Help
    By superman_86 in forum Excel General
    Replies: 3
    Last Post: 07-27-2009, 11:08 AM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1