| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup images within cells in another workbook
Hello, does anyone know if it is possible to vlookup one spreadsheet to
another to return an image within a cell? EG I would like to have a vlookup to return a set value into column A, then a vlookup in column B to use the value in column A to return an image from within a cell of another workbook. Thankyou |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup images within cells in another workbook
J E McGimpsey shows how you can lookup pictures he
http://www.mcgimpsey.com/excel/lookuppics.html Hope this helps. Pete On Dec 9, 9:13 pm, Lee-anne wrote: Hello, does anyone know if it is possible to vlookup one spreadsheet to another to return an image within a cell? EG I would like to have a vlookup to return a set value into column A, then a vlookup in column B to use the value in column A to return an image from within a cell of another workbook. Thankyou |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup images within cells in another workbook
But not from another workbook and the images have to be stored in the workbook
where they are to returned. Gord Dibben MS Excel MVP On Mon, 10 Dec 2007 01:12:47 -0800 (PST), Pete_UK wrote: J E McGimpsey shows how you can lookup pictures he http://www.mcgimpsey.com/excel/lookuppics.html Hope this helps. Pete On Dec 9, 9:13 pm, Lee-anne wrote: Hello, does anyone know if it is possible to vlookup one spreadsheet to another to return an image within a cell? EG I would like to have a vlookup to return a set value into column A, then a vlookup in column B to use the value in column A to return an image from within a cell of another workbook. Thankyou |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup images within cells in another workbook
Thankyou very much to both of you for your help!
"Gord Dibben" wrote: But not from another workbook and the images have to be stored in the workbook where they are to returned. Gord Dibben MS Excel MVP On Mon, 10 Dec 2007 01:12:47 -0800 (PST), Pete_UK wrote: J E McGimpsey shows how you can lookup pictures he http://www.mcgimpsey.com/excel/lookuppics.html Hope this helps. Pete On Dec 9, 9:13 pm, Lee-anne wrote: Hello, does anyone know if it is possible to vlookup one spreadsheet to another to return an image within a cell? EG I would like to have a vlookup to return a set value into column A, then a vlookup in column B to use the value in column A to return an image from within a cell of another workbook. Thankyou |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cells based on conditions in one workbook to another workbook | Excel Discussion (Misc queries) | |||
| Vlookup with Images | New Users to Excel | |||
| VLOOKUP IMAGES | Excel Worksheet Functions | |||
| in excel paste images to specific cells that can be sorted | Excel Discussion (Misc queries) | |||
| how can you link images to cells? | Excel Discussion (Misc queries) | |||
Linear Mode
