Seems like Luke's suggestion of a Vlookup would be the best, but you could
also try:
=if(b1="yellow","basic", if(b1="green", "primary","the alternative"))
Put if into b1 and copy down??
--
smither fan


"ABBY" wrote:

i am trying to create a formula to allow the cell to autopopulate a category.
For example
If I type "yellow" in B1 I want "BASIC" to appear in A1
If I type "green" in B2 I want "PRIMARY" to appear in A2