vlookup and picture
 

Hi,
help is needed... newbie in vlookup.
I would like to lookup a certain serial number of a hardware with a
picture of it.

On the first sheet, it's the lookup formula,
the second sheet has all the information of various serial numbers with
the configuration and picture which describes that particular serial
number.

I do not know if vlookup is capable of providing me with a range of
cells at one time.
Say... I type the serial number 9998, I would like to be able to show
the configuration as well as the picture of it. Each serial number has
a range of 4 columns and 7 rows.

can vlookup do this?
your advice is needed.
-youth..

vlookup and picture
 

Hi youth

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"youth" wrote in message oups.com...
Hi,
help is needed... newbie in vlookup.
I would like to lookup a certain serial number of a hardware with a
picture of it.

On the first sheet, it's the lookup formula,
the second sheet has all the information of various serial numbers with
the configuration and picture which describes that particular serial
number.

I do not know if vlookup is capable of providing me with a range of
cells at one time.
Say... I type the serial number 9998, I would like to be able to show
the configuration as well as the picture of it. Each serial number has
a range of 4 columns and 7 rows.

can vlookup do this?
your advice is needed.
-youth..

vlookup and picture
 

thanks ron, i will experiment on it.