type MI in cell, have Michigan show in adjacent cell

[Guest]

How do I type MI in a cell and have Michigan appear in an adjacent cell?

 

[Paul B]

shark, one way, =IF(A1="MI","Michigan","")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Nick Hodge]

Shark

You could put it (or I suspect you want more than one state, so all) in your
autocorrect list. Could be a pain with OR for example though

Alternatively, if it IS all states, you could make a table on another sheet
(hidden if you like) and reference it with a VLOOKUP formula (States in
A1:A52 on sheet2 MN, Michigan, etc)

=IF(A1="","",VLOOKUP(A1,Sheet2!$A$1:$B$52,2,FALSE)

Then typing any state in A1 will return the state name from the table

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk