I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL

[WERNER SLABBERT]

PLEASE CAN ANY ONE HELP ME ON THIS FUNCTION OR STRING?
I WANT TO CREATE A BASIC RETRIEVAL WHEN I TYPE IN A ITEM NUMBER EXCEL MUST
RETURN THE DESCRIPTION AND THE CORRESPONDING PICTURE FROM EITHER ANOTHER
SHEET OR A PLACE ON MY HDD.

 

[Shane Devenshire]

Hi,

You probably would need to use VBA in which case we would need to know a lot
more. Where is the picture? If it is a file what is its name and location?
Can it be either in the spreadsheet or on the disk? How do you know where
to look?

Unrelated - try not to type in all CAPITAL letters - that is considered
shouting on the internet, and is very hard to read.

Cheers,
Shane