ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert a picture to a cell address. (https://www.excelbanter.com/excel-discussion-misc-queries/225858-convert-picture-cell-address.html)

Hector

Convert a picture to a cell address.
 
Have a file containing .tif images. The images have been bought into an excel
sheet and sized so as to be readable (40 H x 9 W). At the moment they are
manually placed next to the data they represent. Ideally, I would like to use
a function like VLOOKUP and retreive these pictures when the user enters a
code they relate to . I'd like to retreive these pictures from ...
a. the oiginal file were the images are kept...
b. if not, then from a seperate workbook...
c. if not, then from a seperate sheet in the same workbook...
d. at worst, from the same sheet were tey are now.



FARAZ QURESHI

Convert a picture to a cell address.
 
Check out http://www.mcgimpsey.com/excel/lookuppics.html
Best o luck

"Hector" wrote:

Have a file containing .tif images. The images have been bought into an excel
sheet and sized so as to be readable (40 H x 9 W). At the moment they are
manually placed next to the data they represent. Ideally, I would like to use
a function like VLOOKUP and retreive these pictures when the user enters a
code they relate to . I'd like to retreive these pictures from ...
a. the oiginal file were the images are kept...
b. if not, then from a seperate workbook...
c. if not, then from a seperate sheet in the same workbook...
d. at worst, from the same sheet were tey are now.




All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com