Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.. |
#2
|
|||
|
|||
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.. |
#3
|
|||
|
|||
vlookup and picture
thanks ron, i will experiment on it.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Dynamic Range for Function (Vlookup etc) | Excel Worksheet Functions | |||
how can I insert a picture conditional on another cell | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions |