| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert ADDRESS() text result to cell reference | Excel Worksheet Functions | |||
| how to convert excel data into picture | Excel Discussion (Misc queries) | |||
| linking a picture to a web address in a table | Excel Discussion (Misc queries) | |||
| how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
| how can i convert an email address to a web address | Excel Worksheet Functions | |||
Linear Mode
