ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   vlookup images within cells in another workbook (https://www.excelbanter.com/excel-worksheet-functions/169040-vlookup-images-within-cells-another-workbook.html)

Lee-anne

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

Pete_UK

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



Gord Dibben

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



Lee-anne

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





All times are GMT +1. The time now is 04:17 AM.

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