VlookUp problem with a Combobox and Cell Stored as Text

[Iain A]

Hi any help would be appreciated, I am attempting to use a Vlookup from the value in a combobox with a linked cell the cell keeps storing the value as text but to get the Vlookup to work I have to manually convert the cell to a number, I have tried this both in the formula bar and vba:

Formula

=IFERROR(VLOOKUP(K4,Departments!A:C,3),"Department Code")

vba

Private Sub cboDeptNum_Change()
Range("F11").Value = Application.VLookup(Me.cboDeptNum.Value, Sheets("Departments").Range("A:C"), 2, "Department Title")
End Sub

 

[bosco_yip]

Hi,

See attached file and check if it is OK ?

Regards
Bosco

 

[Iain A]

Hi bosco yes that works perfectly thanks so much