Filtering by multiple values in row using a combo box

[wbstadeli]

Hi All,

I want to create a database with a lot of tools that we use for our company. The info will have price/part number/type/etc on each item. Using a simplified version, here is what i would like to achieve. When i type words/numbers in a combo box, i want it to "sort" my extensive list of products (by rows). I can do all this using a single cell to match my "linked cell" from my combo box, but i dont know how to add multiple cells for it to match up with.

Example: See table below


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]list row #:[/TD]
[TD]Type[/TD]
[TD]Brand[/TD]
[TD]Length[/TD]
[TD]Drill Size[/TD]
[TD]Linked Cell from combobox[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]Jobber[/TD]
[TD]Nachi[/TD]
[TD]3"[/TD]
[TD].125[/TD]
[TD][/TD]
[TD]=IF(ISNUMBER(SEARCH($F$1,E2)),A2,"")[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Stub[/TD]
[TD]OSG[/TD]
[TD]4"[/TD]
[TD].25[/TD]
[TD][/TD]
[TD]=IF(ISNUMBER(SEARCH($F$1,E3)),A3,"")[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]Extra-long[/TD]
[TD]YG[/TD]
[TD]9"[/TD]
[TD].125[/TD]
[TD][/TD]
[TD]=IF(ISNUMBER(SEARCH($F$1,E4)),A4,"")[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]Short[/TD]
[TD]PDT[/TD]
[TD]1''[/TD]
[TD].375[/TD]
[TD][/TD]
[TD]=IF(ISNUMBER(SEARCH($F$1,E5)),A5,"")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Currently i can sort this by:

-Entering a value in the combo box, for this case it will be ".125"
-That combo box has a linked cell (F1) so .125 gets entered into F1
-Column (G) has the following formula for each row =IF(ISNUMBER(SEARCH($F$1,E2)),A2,"")
-That returns List row #1 into cell G2 and list row #3 into G4.

That is all fine, except i want to be able to filter it down further using all the cells in the row not just "E".

So the same combo box i would type for example ".125 jobber" and it would filter down to only returning list row #1 into G2 and now list row #3 (G4) would be a blank because that row doesn't contain the word "jobber" in it. Is this a possibility??

I appreciate your time to look at this!!