MrExcel Publishing
Your One Stop for Excel Tips & Solutions

automatic fill-in

Posted by Tove on August 10, 2001 9:36 AM

I'd like to be able to fill out an abbreviated code in a spreadsheet and have the full name associated with it be filled in automatically in an ajacent cell. Is this perhaps possible, and if so, how does one do it??

Posted by Cory on August 10, 2001 9:55 AM

The easiest way to do it is:

You want to enter the abbreviation in A1 and you want the full name in B1.

In B1 enter the formula:

=if(A1="crf","Cory Robert Ferguson",if(A1="T","Tove",""))

You can nest the if statement out like that up to seven layers.

A more difficult way, but more efficient is to use a vlookup and have it reference a table holding the values for the abbv.s and full names. If you want that, just ask:-)