I would like to search 5 unique product sheets (one at a time) through a drop down selection interface on a separate sheet.
The search is based on 4 input criteria (length, width, height and mass) and match the closest record containing the next largest dimensions across these 4 individual criteria in the selected category.
The caveat being that the search should add +2 to each of the inputs searching.
I have a working version in a single worksheet based on the formula:
I'm having difficulty implementing this across multiple worksheets.
The current formula is dependent on a “UID”; see thread #2 of:
Extract record by multiple criteria.
Can this be accomplished without the dependence on the “UID”? (UID column sums the 4 criteria, but must be in descending numerical order which isn't quite feasible for my purposes.)
The use case for this is a packaging database where I'm trying to determine the next size up.
The search is based on 4 input criteria (length, width, height and mass) and match the closest record containing the next largest dimensions across these 4 individual criteria in the selected category.
The caveat being that the search should add +2 to each of the inputs searching.
I have a working version in a single worksheet based on the formula:
Code:
[COLOR=#333333] =INDEX(N:N,MATCH(((B3&C3&D3&E3)*1),S:S,-1),1)[/COLOR]I'm having difficulty implementing this across multiple worksheets.
The current formula is dependent on a “UID”; see thread #2 of:
Extract record by multiple criteria.
Can this be accomplished without the dependence on the “UID”? (UID column sums the 4 criteria, but must be in descending numerical order which isn't quite feasible for my purposes.)
The use case for this is a packaging database where I'm trying to determine the next size up.
