Advanced Data FIlter: Two columns: Numbers as text, Characters as text: Results different

Heck, I don't know how to phrase the issue in the Title line...

I have two columns, the first has numbers, the second has characters, this is from a NAICS listing, excerpt as follows:

Code Description
11 Agriculture, Forestry, Fishing and Hunting
111 Crop Production
1111 Oilseed and Grain Farming
11111 Soybean Farming
111110 Soybean Farming
11112 Oilseed (except Soybean) Farming
111120 Oilseed (except Soybean) Farming
11113 Dry Pea and Bean Farming
111130 Dry Pea and Bean Farming
11114 Wheat Farming
111140 Wheat Farming
11115 Corn Farming
111150 Corn Farming
11116 Rice Farming
111160 Rice Farming
11119 Other Grain Farming
111191 Oilseed and Grain Combination Farming
111199 All Other Grain Farming

I have formatted both columns as text.

I have further created my filter criteria as such:

Code Description


with both cells under each column title being formatted as text.

Now, I want to filter on either column depending on user choice, and am able to do so, but I only get the desired result filtering on "Description" and not on "Code".

When I filter on "Description" and put in a letter I get ALL results that start with that letter. For instance if I entered the letter "O" I would get the following with which to populate my listbox:
1111 Oilseed and Grain Farming
11112 Oilseed (except Soybean) Farming
111120 Oilseed (except Soybean) Farming
11119 Other Grain Farming
111191 Oilseed and Grain Combination Farming

However...

When I put in the first digit in "Code" (Please note, the first digit in the entire first column goes on to include 1-9), I only get an entry that corresponds to that specific entry, even if I append * to it. For better example, if I enter 11119, instead of getting:

11119 Other Grain Farming
111191 Oilseed and Grain Combination Farming
111199 All Other Grain Farming

I only get:
11119 Other Grain Farming

Is there a way to get what I want?

Thank-you all!!!

Have you considered just using regular filters?
Home tab/Editing/Filter and Sort/Filter

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

OK! Sorry it took me so long!

I believe the attached file will demonstrate the problem I described above.

The worksheet has a button to open the selection form. Once the selection form is open you can choose to enter by "direct entry" which is typing in the numbers, or by description.

If "Description" is selected then along the lines of the description of the problem if one enters "oil" (without quotation marks), a list of anything with "oil" will appear in the expanded box. If one selects "Direct Entry" and enters "11", only the item that is "11" appears, not "111" nor "1111", nor...

The reason for wanting everything that starts with a given numerical sequence is that these categories start with a broad base of a field and gradually narrow it down to a specific, so I might know that "11" is "Agriculture, Forestry, Fishing and Hunting" and know that the industry that I want is somewhere within that major classification, but wish to see all the items that start with "11" to narrow down the search or select the specific item, perhaps looking for "112112" which would be "Cattle Feed Lots". This also applies to if I knew the industry that I was searching for was within "112" or within "1121" or even "11211".

You can disregard columns A-F - that was part of a "work in progress"

Thank-you for taking the time to review!