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