VBA-combobox - Search as you type, auto fill in other cells

[Vicarious]

I am new to VBA and am struggling to get this to work. I have a macro driven search as you type combo box which works great, now I need this to fill in the bin location on the selected item (yellow cell). I know this will be very easy for someone but I am struggling getting this to work.

[6StringJazzer]

I have linked the combobox selection to cell B5 and provided a formula that looks up the selection. I did not touch any code. Note that the formula in C5 is an array formula.