Hello,
I have searched the web and threads but cannot seem to locate an answer to what I'm trying to achieve.
Is there a way to have Excel narrow the searchable results for a vlookup if other parameters are met first?
I have a long list of pack products that have subproducts under them. I only want Excel to search for subproducts based on the pack that is selected. Further more, I then need Excel to return a part number based on the qty they want to order within that subproduct.
In the example below if the customer were to select Premium Tires and enter in qty 2, I need excel to return the part # AAAAA-2.
I think I want to accomplish this with a vLookup function but I cannot seem to figure out how to incorporate the multiple levels of validation. Your help is greatly appreciate!
<TBODY>
</TBODY>
I have searched the web and threads but cannot seem to locate an answer to what I'm trying to achieve.
Is there a way to have Excel narrow the searchable results for a vlookup if other parameters are met first?
I have a long list of pack products that have subproducts under them. I only want Excel to search for subproducts based on the pack that is selected. Further more, I then need Excel to return a part number based on the qty they want to order within that subproduct.
In the example below if the customer were to select Premium Tires and enter in qty 2, I need excel to return the part # AAAAA-2.
I think I want to accomplish this with a vLookup function but I cannot seem to figure out how to incorporate the multiple levels of validation. Your help is greatly appreciate!
Pack Product | SubProduct | QTY | Part # |
Premium Tires | Multi-tread | 1 | AAAAA-1 |
Premium Tires | Multi-tread | 2 | AAAAA-2 |
Premium Tires | Multi-tread | 4 | AAAAA-3 |
Standard Tires | Multi-tread | 1 | CCCCC-1 |
Standard Tires | Multi-tread | 2 | CCCCC-2 |
Standard Tires | Multi-tread | 4 | CCCCC-3 |
<TBODY>
</TBODY>