vlookup to obtain pictures

R

Rosebud

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
 
N

Niek Otten

Look here:

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
Top