Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
type MI in cell, have Michigan show in adjacent cell
How do I type MI in a cell and have Michigan appear in an adjacent cell?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
type MI in cell, have Michigan show in adjacent cell
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 "shark" wrote in message ... How do I type MI in a cell and have Michigan appear in an adjacent cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
type MI in cell, have Michigan show in adjacent cell
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 HIS www.nickhodge.co.uk "shark" wrote in message ... How do I type MI in a cell and have Michigan appear in an adjacent cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |