So I working on a project in Excel 2010, I have 3 tabs, one is in a form set up that a user enters info into, one is where the form information is stored, and 3rd has a company name list that populates a dropdown on the form tab and a column beside it that has matching companyID #'s.

What I need to do is when a user picks a company from the dropdown on the form tab, I need to be able to retrieve its corresponding companyID that is stored in the list tab

I need that corresponding companyID to be displayed on the storing tab, in the same row where all the other form info is retrieved to.

Does anyone know how id go about doing this? I've tried different functions but cant seem to get the right one. And if you suggest to use VBA, please tell me how.

if i understood correctly:

user selects say letter E from list.
that has a code number of 5 [5th letter in this example]

as you already have the letter E, just do a vlookup in the next cell using the source of the dropdown as your table. simple !

if you prefer vba then load both cols into dropdown and when selected paste
col1 and col2 into the storing tab.
i would tell you the exact syntax but cannot remember.
its something like
with listbox .selected
a = .item (0)
b = .item (1)
end with
then paste those variables (a and b) into the excel cells.
ie range("g14") = a [change the range to whatever cell you want]
post back if you need more info