I have a cell linked to a combobox to get the data in the cobobox that matches what is typed.
Works fine only I have multiple entries which are the same only one is 12ft and the other is 15ft.
How can I make it get the correct size i need?

Example:

Style Size
80041 1200
80041 1500

When I type the style 80041 it goes to the first entry
I want to be able to choose which size I want it to go to.

Can this be done?

Thanks
Charles