Filtering a DefinedName that a ComboBox pulls from within a VBA Form

I am a couple days new to VBA, I was wondering if it was possible for a UserForm to populate specific cells based on a combobox selection within the UserForm.

As well as the ComboBox selection coming from (ThisWorkbook.Names().RefersToRange) but filtering based on the column to the right.

I.e.

Column C is the Shelving Unit Number with the defined name.

Column D is if the Shelving Unit Number is being used by someone or not.

If this is a possibility, I would be grateful to hear how.