50 States, Drop-Down List, select a state then produce the # for that state

[Sir CHARLES]

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.

[Sir CHARLES]

Basically Sheet2 A1 is = A2 so if on Sheet1 A1 CA is selected it's going to return the value in A2 for CA.

[protonLeah]

deleted.....

[Ursul]

On sheet 1 in cell B1 put this formula: =VLOOKUP($A$1,Sheet2!$A$1:$B$56,2,FALSE)

Cheers

[Sir CHARLES]

I thought VLOOKUP was the answer but couldn't quite get it figured out, awesome and thanks for the quick reply...

[Ursul]

You're welcome Sir Charles ... always a pleasure to help and if you wouldn't mind clicking on the star to "Add Reputation" I'd appreciate it.

All the best

[Sir CHARLES]

Ursul, done my friend, anytime.....