in cell A1 place an if statement (=IF(B1="yellow","BASIC","Why Not
Yellow?"))but thats will only show basic if its yellow and not for any other
color. If they dont say "yellow" then "why Not Yellow" will be in A1. you can
do the same for A2 just with different wording.

"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