Automatic answer in msgbox based on mapping

Hello,

I'm completely new in the forum, and also quite new to VBA.

I work in HR and have a list of job functions that I need to map according to a table containing financial data. Eg.:

HR job function = Construction
Finance data = 142
HR Job function = Marketing
Finance data = 143

Now, I want to create an input box where my user chose from a drop down list the HR job function. Once the HR job function selected, the corresponding Finance data info should appear in a MSGbox. The mapping of HR job functions and Finance data is all stored in an excel file.

Can anyone help me with a code that could do this? I tried looking around on other forums but didn't find anything that looked like this.

Thanks a mill in advance!

Thanks a lot! That worked

Thanks a lot! That worked wonders :)

See the response post for an

See the response post for an example workbook