If Then

[Gregg_Dohrn]

Good morning! I would like to simplify a data entry process. Instead of typing entries in several cells, I would like to use a numerical code. For instance, if I type 11 in cell A1, then Newport would appear in cell A2, and Current Planning would occur in cell A3. If I typed 12 in A1, then Newport would appear in A2, and Comprehensive Planning would occur in cell A3, and so on. Any suggestions on how to do this? I will have 10-20 codes. 

[#2]

@Gregg_Dohrn 

Create a lookup table like this, on a sheet named (for example) List:

On the sheet where you enter the code in A1, enter the following formula in A2:

=IFERROR(VLOOKUP(A1,List!$A$2:$C$20,2,FALSE),"")

And in A3:

=IFERROR(VLOOKUP(A1,List!$A$2:$C$20,3,FALSE),"")