Trying to use a dropdown of one field to retrieve a value from another field

What I have is a very "rigid" formatted spreadsheet page, that is printed and submitted to the home office. What the end result that is wanted, is the person wants to select a text value from a drop down list and have it return its corresponding numeric value.

The information is on a separate page of the spreadsheet with the first column being the numeric value and the second being the Text name of that value.

EX:
TabName: Name Codes
Code Name
1 Adams
2 Jones
3 Peter
4 John

On the main page, the person wants to select "Adams" from a drop down list but in the same field have it return a 1, instead of the word 'Adams'.

Any help is appreciated.
Thanks in advance,

Tom Cusick

Hello sktneer/Tom - - I tried to follow the instructions but it didn't work for me. I am sure that it's me as I know nothing about VB. Note: I downloaded Sktneer's example, when I chose Adam from the dropdown, Adam was returned, not 1. ...and yes, I did enable editing.

I have the same ask.
- My Dropdown in Column I: Safety, Financial, Quality.
- The data that I would like to return in Column J: 15, 30, 45 respectively

How do I make this work with my spreadsheet. Thank You, so much, in advance.