From a table of information I would like to display a full row or rows of
data of data based on a set of lookup criteria if a1:a20 has a value = to 20
+ or- 10% and the same row has a value of 50 + or - 10% b1:b20

The values will always change, therfore I would like the formula to look at
a cell where I can input the required value

To help you understand the spreadsheet is a simple list of equipment model
numbers with capacities fan dimensions and noise data I would like to input 3
selection criteria and be presented with each row that complies with in 10%

Thank for any help you can provide