Hi, thanks for help...

list example.xlsx

Sheet2 has my info, Sheet2/A1 is state abbreviations, Sheet2/A2 their numbers for that state.

Sheet1 is using this information as Sheet1/A1 has a drop-down list of the states. Once a state is selected it needs to return the number value for that state in cell Sheet2/A2.