Search values in data table that are greater than cell value

I have a formula that I need to have expanded to included finding filtered data based on a value in a cell - one cell is greater than and one cell is less than.

Formula - (Array)

{=IFERROR(INDEX(Total!A$2:A$88,SMALL(IF(ISNUMBER(SEARCH(TRIM($B$2),Total!$B$2:$B$88)*SEARCH(TRIM($H$4),Total!$L$2:$L$88)*SEARCH(TRIM($H$2),Total!$H$2:$H$88)*SEARCH(TRIM($B$8),Total!$K$2:$K$88)*SEARCH(TRIM($B$6),Total!$J$2:$J$88)*SEARCH(TRIM($B$4),Total!$I$2:$I$88)),ROW(Total!$A$2:$A$88)-MIN(ROW(Total!$A$2:$A$88))+1),ROWS($A$1:$A1))),"")}

Greater than Cell - $H$6
Less than Cell - $H$8

Data Column - (Total!$G$2:$G$88)

I included a sample to work on.

Premier Quick Help.xlsx

Add a condition in Coumn G to populate BTG only within the minimum and maximum range and make all othe row cells conditional on whether the BTG column populates or not

In cell G12 use

Please Login or Register  to view this content.

In A2 use

Please Login or Register  to view this content.

Adapt for all other columns and remember use Ctrl+Shift+Enter

there are three version of this file (1, 2, 3), each with increasing level of automation (and err... simplification). take your pick, based on preference and/or performance. let me know if you have any question.

Aha..didnt tackle the spaces. I'd go with first option given by icestationzbra

the reason is that there are some #N/A values in column G. use the following formula in 'Quick Search A12':

Please Login or Register  to view this content.