Hello All!!
I'm looking for formulas that will enable the following.
1. perform a search for box dimensions that are similar or over dimensions entered into search fields on the dashboard. The search fields will be the X Y Z dimensions of the box needed.
2. The results must be able to include all possible results while filtering out each dimension that falls below the value entered, for example if the dimensions entered into the search fields are X = 120, Y=58, Z=35 the results must be above each entered value. if any value falls below the entered value it should be excluded.
3. Can it be possible to set a tolerance variable into the dashboard that can fine tune the results. for example if the tolerance value is 12, then the results for the X Y Z dimensions should only display all results that are above the entered values up to the tolerance value of 12.
4. The sheet consists of varying styles (identified by the tabs)of boxes so it will need to work across all styles and populate the results in the dashboard.
The sheet is attached and the results need to display the entire row.
I'm looking for formulas that will enable the following.
1. perform a search for box dimensions that are similar or over dimensions entered into search fields on the dashboard. The search fields will be the X Y Z dimensions of the box needed.
2. The results must be able to include all possible results while filtering out each dimension that falls below the value entered, for example if the dimensions entered into the search fields are X = 120, Y=58, Z=35 the results must be above each entered value. if any value falls below the entered value it should be excluded.
3. Can it be possible to set a tolerance variable into the dashboard that can fine tune the results. for example if the tolerance value is 12, then the results for the X Y Z dimensions should only display all results that are above the entered values up to the tolerance value of 12.
4. The sheet consists of varying styles (identified by the tabs)of boxes so it will need to work across all styles and populate the results in the dashboard.
The sheet is attached and the results need to display the entire row.