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