searchable drop-dwn in excel and vllookup to display data

[NetSy]

hi,

how can i retrieved data selected from searchable combo box values and vlookup with data in sheet3. e.g if 'ban ki moon' is selected then roles should be "Politician" displayed in the roles cell.

 

[Knoet]

See attached.
Set properties like the pictures.


Code goes in sheet Searchable_dropdown_list1 (2) module.

Private Sub ComboBox1_Click()
    [H7].Value = ComboBox1.Column(1)
End Sub

 

[NetSy]

hi, thxs a lot.
I have more query & help pls..
In sheet3 of the excel, I have added some more columns i.e
(C = Category and D = Country) and I want to return values in column D when the specific record is selected in the drop-down.

how can I amend the code pls?​

 

[Knoet]

Hi,
Like this?