What command do I use?

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

ok i think what you are looking for can be done best with a Vlookup you just need a chart with the specific words on the left we will call it column A and the dates that match on the right column B. column c will be where the person chooses the words like "production" then in your cell you would use this formula

Formula:

Please Login or Register  to view this content.

I would suggest limiting the words the user can input by using a dropdown list and forcing them to only use the words you want.

Thanks for the quick response and the help!

Vlookup did it...thanks