CCL and views?

Hello,
I have the following scenario -
I have a team which controls products. each product is represented by a number. each team member is responsible is responsible for a range of products based on the last 2 digits of the product number (ie, team member one is responsible for products where the last 2 digits of the product number are between 00 and 07, member two between 08 and 16, etc.).

what I would like to do is have a block on my frontpage where a customer can enter the last 2 digits of a product and click a button which would return the contact information of the team member who is responsible for that product.

I thought I would be able to create a custom content type for the team members, and then create a custom view that would use an exposed filter to narrow down the search results, but I cannot figure out how to use node information in the filter.

Can anyone point me in the right direction.

Thanks for any thoughts.