Hi, I have been really taxed in my knowledge of Excel lately and could use some help. If someone could tell my what command I would use for the following scenario so I could research it I would be greatly appreciative. I don't think I am searching using the right terms in Google.

I need date values in a column to be decided upon the value in another column. It would be like this, If column A is a word such as "Production" column B would give a specific date such as 3/22/2015. If it is a word such as "Test" it would give another date such as 4/4/2015. Column A would have about 10 unique values and so would column B.

Could someone tell me the basic command please? I have Excel 2013.

Thanks