how to lookup image from different excel

Question

I am creating an excel workbook file with one of the column containing a title of an image that is in another excel workbook file, that excel file contained huge database of images how to lookup images form that excel workbook file with their individual title

Note: these are two different Excel workbooks. And the condition is we can't merge file because imageDatabase file is so heavy up to 25MB for that reason excel is get not responding or force close.

file for example: https://drive.google.com/a/flygoldfinch.com/file/d/0B9VV_J4sKTatdDBEZ01GNHg3Y0k/view?usp=docslist_api

durbnpoisn · Accepted Answer · 2015-11-13 14:52:24Z

2

Any reference to a cell in Excel can be performed on any other sheet, be it in the same file, or an outside file.

A reference to another sheet within the file looks like this:

='sheetname'!M20

The same thing works if that sheet is in a different file

='[file.xlsx]sheetname'!$H$726

Knowing that the reference will work that way, you can write any formula with it. This includes VLOOKUPs, or anything else you need to do.

A good shortcut to make this easier is to have both files open, click the cell you want to make the reference in, type =, then switch to the other file, click the cell you want, and hit return. Your reference is made.

answered Nov 13, 2015 at 14:52

durbnpoisn

4,6792 gold badges19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to lookup image from different excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related