Thread: how to autopopulate a cell using a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abby Abby is offline
external usenet poster
  
Posts: 26
Default how to autopopulate a cell using a formula
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
Reply With QuoteReply With Quote