Storing UTMs as a "station"

[Asovie]

Hi, I am a biologist working on rabbits in South florida. What I need help with is teaching excel to recognize the UTMs of my monitoring stations that i return to weekly. Specifically I want to be able to type S1N and have excel return the N coordinate for Station 1, (for example S1N = 123456, S1E = 1234567 ect ) I know this can be achieved by doing a search and replace but the program won't let me store the values there long term. UTMs are 13 characters long so the likleyhood of making a typo is huge if I have to enter the values manually every time.

Thanks for any help or suggestions!

Adia

[mrice]

Suggest looking at the VLOOKUP function. Otherwise post a copy of the sheet to explain further.

[CRIMEDOG]

Create a Table on Sheet2! Column A: S1N etc... Column B: 123456...
You can name the range UTM
On Sheet1 - Column A can be your entry for S1N...
Column B: =iferror(vlookup($A2,UTM,2,False),0) - I am assuming there is a heading and the data entry beginds in Row 2
copy B2 and paste down the column to the end of your entries.