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

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