Dave!
I found the solution in your suggested formula:
myPC = Application.Index(myWS.Range("a:a"), Application.Match(myPN,
myWS.Range("b:b"), 0))
myPC refers to cell A10 of course.

Thanks a mille!
Mats

"Dave Peterson" wrote:

Depending on how many fields are used, why not just keep adding them to the
combobox list (but hide them). That's what that code did.

Mats Samson wrote:

OK!
But I think I can use a HLookup formula to get the leftmost cell-value in
the row of the selected CB2-value.
If you have any ideas you€„¢re heartily welcome!
Regards
Mats

"Dave Peterson" wrote:

I don't open attachments or workbooks from others.

I thought that the code populated both the product description and product code.



Mats Samson wrote:

Oh yes, it works! If you mean the code discussion, yes perfectly alright!
But the formula doesn€„¢t, as explained above.
The remaining problem is that I want the product code as well, at the same
time as I choose the product. The product codes you can design so the
connected product comes in blocks, in my case supplier wise. It€„¢s simple
database handling, whether it€„¢s
products, customer or suppliers, you need a unique common denominator.
We created a new problem when extracting a list out of the product db, we
lost touch with the €ŀœindex value€ÂÂ�, the product code. Still, I want the
product code as well, for the other formulas to work correctly. If you need
further explanation, I€„¢d better send you my files so you can see what I want
to achieve. In such case, please send me an email address where I can reach
you.
Best regards
Mats



--

Dave Peterson