ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vlookup to obtain pictures (https://www.excelbanter.com/excel-discussion-misc-queries/143204-vlookup-obtain-pictures.html)

Rosebud

vlookup to obtain pictures
 
My problem is this:
Based on an employee number, I want to extract the job title and name from
two columns and their picture from another column. I can extract the text
but I do not know if I can use Excel to store the pictures and use vlookup
extract the appropriate picture based on the employee ID.

How can I link a different picture to each item in my table or do I need to
use Access?

Many thanks

Niek Otten

vlookup to obtain pictures
 
Look he

http://www.mcgimpsey.com/excel/lookuppics.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rosebud" wrote in message ...
| My problem is this:
| Based on an employee number, I want to extract the job title and name from
| two columns and their picture from another column. I can extract the text
| but I do not know if I can use Excel to store the pictures and use vlookup
| extract the appropriate picture based on the employee ID.
|
| How can I link a different picture to each item in my table or do I need to
| use Access?
|
| Many thanks




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

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