Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question on vlookup
I am setting up a Quality Check sheet for various suppliers.
The sheet contains various information related to various products. Each product is made by different suppliers. I want to use VLOOKUP to get data related to particular product. I have sheets with details for each supplier. I would like to know how can i change the range in each vlookup function so that, once i select a particular supplier on my quality check sheet, for each detail required on that page, the vlookup function selects the range for that selected supplier automatically. Meaning once i select the supplier the variuos vlookup on the main sheet select the data only from the range of the selected supplier. Is there anyother way to do it. Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
question on vlookup
Set up your Vlookup to use a range variable as the 2nd argument. When you
select a supplier, set that variable to the corresponding range. Then do your lookup. General outline: ****** Dim SupplierInfoRange as Range Select Case SupplierSelection Case "Supplier Able" Set SupplierInfoRange = range_containing_SupplierAble_info Case "Supplier Baker" Set SupplierInfoRange = range_for_SupplierBaker ' ... yada, yada End Select MyResult = Vlookup(item_detail_to_look_for, SupplierInfoRange, column_number_to_return, T_or_F) ********** HTH, -- George Nicholson Remove 'Junk' from return address. "Demi" wrote in message ... I am setting up a Quality Check sheet for various suppliers. The sheet contains various information related to various products. Each product is made by different suppliers. I want to use VLOOKUP to get data related to particular product. I have sheets with details for each supplier. I would like to know how can i change the range in each vlookup function so that, once i select a particular supplier on my quality check sheet, for each detail required on that page, the vlookup function selects the range for that selected supplier automatically. Meaning once i select the supplier the variuos vlookup on the main sheet select the data only from the range of the selected supplier. Is there anyother way to do it. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Worksheet Functions | |||
VLOOKUP Question | Excel Worksheet Functions | |||
VLOOKUP Question | Excel Discussion (Misc queries) | |||
Question on Vlookup | Excel Worksheet Functions |