VLookup Excel table to populate combobox in userform

I have a userform and have comboboxes for station # and station name. Each # has a unique name and vice versa. I would like the user to be able to either select the station # and have the corresponding station name populate in the combobox or the other way around.

I tried a VLookup of the table in my code, but I can't get it to work. I get a type mismatch error.
Here is the code for changing the station #:

Private Sub cboStationNum_Change()
cboStationName.RowSource = Application.VLookup(cboStationNum.Value, ATLCTable, 2)
End Sub

I'd like to know what I'm doing wrong with the VLookup and if you have any better suggestions on how to get the same functionality that's fine too.

Thanks!

Thanks ... I'm not really familiar with that though. Here is how my named range and userform look:

Capture2.PNG

Station # Name
18 PITT
19 GRBG
25 DUBO
35 OILC
63 ALTO
84 HRBG
111 HRBL
200 WMPT
366 PTSV
401 PHIL

I want my combobox to automatically find the corresponding # or name depending on what the user selects while in the userform