Auto-update the cell when another cell(Drop Down list) is changed

[meetz]

Hi,

How this vlookup formula result will auto update with the changes?

Below coding explanation - I want to update Cell G4 when selection is done from drop down list in F4 and data from A2:B6.

Sub vlookup()


Range("G4") = Application.WorksheetFunction.vlookup(Range("F4"), Range("A2:B6"), 2, False)


End Sub

Please help.

Thank you in advance