• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

VLOOKUP link to images in a folder|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / VLOOKUP link to images in a folder|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumGeneral Excel Questions & Answe…VLOOKUP link to images in a folder
sp_PrintTopic sp_TopicIcon
VLOOKUP link to images in a folder
Avatar
jon rhodes

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
June 18, 2018
sp_UserOfflineSmall Offline
1
June 18, 2018 - 6:51 pm
sp_Permalink sp_Print

Hi, I'm not good with these things and I've tried looking online but I can't find anything that I can actually understand.

 

I have a folder on my PC containing images (jpgs). And I have an excel spreadsheet containing details of the items relating to those images. I regularly update the folder to add new images for the items already in the spreadsheet. I will also on occasion add items to the spreadsheet and add the images to the folder at a later date.

 

I would like to be able to use VLOOKUP to link that images folder with the image name to the corresponding item in the excel spreadsheet, and I would like the spreadsheet to update automatically each time I add a new image to that folder where there is a corresponding line in the spreadsheet.

 

There is a column in my spreadsheet that contains the exact name of the images without the extension. Basically, I want to see in the spreadsheet where I have images for the items and where I don't so that I can obtain images for those that don't. I only want the spreadsheet to show the name of the image file and not a direct link.

 

I hope i've explained it well enough so that you understand what i want. And i do hope you can help me figure this out. Thanks

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
2
June 19, 2018 - 10:55 am
sp_Permalink sp_Print

Hi Jon

You can refer the article below:

https://www.myonlinetraininghu.....-using-vba

Hope this helps.

Sunny

Avatar
jon rhodes

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
June 18, 2018
sp_UserOfflineSmall Offline
3
June 19, 2018 - 8:23 pm
sp_Permalink sp_Print

Thank you.

 

However, all of that information is very confusing and I can't tell if it is exactly what I want because I don't know how to do it myself. I am not excel literate and I really need a dumbed down step-by-step of how to do this (including where i need to click ect).

 

You really have to approach me like i'm as thick as two bricks or I really wont understand :-/

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
4
June 20, 2018 - 12:22 am
sp_Permalink sp_Print

Try downloading the workbook.

The workbook contains only 1 button.

Click the button, select the required folder and click OK

It will create the necessary links for you.

Avatar
jon rhodes

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
June 18, 2018
sp_UserOfflineSmall Offline
5
June 20, 2018 - 1:14 am
sp_Permalink sp_Print

Ok, so i see how that part works.

 

What I'm trying to figure out now is how to pair the file names to the item list using a vlookup. Si i have column 'A' with the item numbers and i want column 'B' to be the link at the side. But not all item numbers have images. Is there any way for me to just click that button and the items that do have images will have the link appear right next to them? And will the links automatically appear where they need to each time a new image is added to the folder? Or will I have to click the button to repopulate the list in excel every time new images are added to the folder?

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
6
June 20, 2018 - 9:10 am
sp_Permalink sp_Print

Please attach an example of your expected result. Include notes if possible.

It will help us to understand what you really wanted.

Avatar
jon rhodes

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
June 18, 2018
sp_UserOfflineSmall Offline
7
June 20, 2018 - 7:43 pm
sp_Permalink sp_Print sp_EditHistory

Image 1 is the list of product codes.

img1.JPGImage Enlarger

 

 

Image 2 is the list of linked images. 

img2.JPGImage Enlarger

 

 

 

Each list is currently in a separate tab.  I want to have all information in one tab.

 

I want to have a VLOOKUP down column 'B' of image 1 with a result explained in Image 3.

img3.JPGImage Enlarger

 

So i want to match my product code list to the image link list populated by the hyperlink button from the workbook I downloaded. 

 

Each time I add a new image to the linked folder, I want the new image link to appear at the side of the corresponding existing product code.

 

Let me know if there's anything you need me to explain in further detail 🙂

sp_PlupAttachments Attachments
  • sp_PlupImage img1.JPG (38 KB)
  • sp_PlupImage img2.JPG (53 KB)
  • sp_PlupImage img3.JPG (48 KB)
Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
8
June 21, 2018 - 10:43 am
sp_Permalink sp_Print sp_EditHistory

I have done some changes to Philip's file that you downloaded earlier.

The assumption is that your product codes are in column A.

The macro will create the link in column B (same sheet as your code) only if the product code image is found.

You will have to run the macro again if there are any addition of new images.

Hope this helps.

Sunny

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Nada Perovic, Denise Lloyd
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6219
Posts: 27276

 

Member Stats:
Guest Posters: 49
Members: 31903
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.