Autofill predifened values help !

[ak803]

Hello,

I want to fill cell e1 with value "GOLD" when I fill cell a1 with value "GL"
Similarly if I fill a2 with value "SL" I want the cell e2 to be filled with value "SILVER"

I WANT TO FILL A COLUMN CELLS WITH SOME PREDIFENED VALUES AND I WANT CELLS IN E CLOUMN TO GET FILLED WITH ASSOCIATED VALUES

PLEASE HELP HOW TO DO IT ?

 

[nmartin]

=IF(A1="GL","GOLD","") & IF(A1="SL","SILVER","")

 

[ak803]

Thx sir
But what if I fill A1 with “sl” I want e1 to be
“Silver”

 

[ak803]

Thx sir
But what if I fill A1 with “sl” I want e1 to be
“Silver”

Ok sorry I got it

 

[Beyond_avarice]

If your only two options are Silver and Gold then.

=IF(A1="GL","GOLD", IF(A1="SL","SILVER","") )

If you intend to have more values than Silver and Gold; you will want to set up a VLookup.