Want to link cells with information from another sheet

[PiscesAngel85]

I've never tried to do this so please pardon me if the description is rough. My company has a new spreadsheet I have to enter my work into for overnight uploading instead of manually inputting everything but now I have to type much more and cannot alter the information sent. For instance instead of typing out a state name is there a way I can enter "AL" into one cell and have the full state name "ALABAMA" populate into the next one?

I can have another sheet with the information but I have never worked with such a complex need in Excel before.

[Speshul]

Create a small table with all of the state names/letter combinations

So like this

AL	ALABAMA
CO	COLORADO

and so on, for all 50 states.


Lets assume this table is on a new sheet called "States", and is in cells A1 through B50



On the sheet you are inputting to, put this formula in cell A1, (or wherever)

=VLOOKUP(B1,States!$A$1:$B$50,2,false)

Now, when you type AL into cell B1, cell A1 will populate with ALABAMA.
You can copy that formula to as many rows as you need!

Hope this helps, and Welcome to Excelforum.