Home

VLookup to an image in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-645682%22%20slang%3D%22en-US%22%3EVLookup%20to%20an%20image%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645682%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20sheet%20in%20excel%20that%20houses%202%20columns%20of%20data%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%2010%20digit%20item%20code%3C%2FP%3E%3CP%3E2.%20Photo%20of%20the%2010%20digit%20item%20code%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20separate%20sheet%2C%20I%20want%20to%20be%20able%20to%20reference%20the%2010%20digit%20item%20code%20in%20column%201%20and%20have%20it%20populate%20with%20the%20image%20in%20column%202.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20figured%20the%20best%20way%20to%20go%20about%20this%20would%20be%20through%20a%20VLookup%2C%20but%20can't%20seem%20to%20figure%20out%20how%20to%20link%20text%20with%20an%20image%20and%20reference%20it%20through%20a%20VLookup.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20tips%2Ftricks%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-645682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-645746%22%20slang%3D%22en-US%22%3ERe%3A%20VLookup%20to%20an%20image%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645746%22%20slang%3D%22en-US%22%3EPlease%20refer%20to%20this%20link%20for%20instructions%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.computergaga.com%2Fblog%2Fcreate-a-picture-lookup-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.computergaga.com%2Fblog%2Fcreate-a-picture-lookup-in-excel%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
skendzi
Occasional Visitor

Hello,

 

I want to create a sheet in excel that houses 2 columns of data:

 

1. 10 digit item code

2. Photo of the 10 digit item code

 

In a separate sheet, I want to be able to reference the 10 digit item code in column 1 and have it populate with the image in column 2. 

 

I figured the best way to go about this would be through a VLookup, but can't seem to figure out how to link text with an image and reference it through a VLookup. 

 

Any tips/tricks appreciated.

 

Thanks!

 

1 Reply
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies