Excel - make data automatically populate in one column based on value in another column?

Let's say Column A is "Fruit" and Column B is "Price". Let's say that Apples are always $1 and Oranges are always $2. How do I make it so that when I type "Apple" in column A, $1 automatically populates in column B; and when I type "Orange" in column A, $2... show more Let's say Column A is "Fruit" and Column B is "Price". Let's say that Apples are always $1 and Oranges are always $2. How do I make it so that when I type "Apple" in column A, $1 automatically populates in column B; and when I type "Orange" in column A, $2 automatically populates in column B?
1 answer 1