AutoPopulate Neighboring Column

Hi, Please give "dummy" help for the excel novice.

I would like to use an =IF statement to autopopulate a neighboring column. In column A we are putting the date of shipments due i.e. "01/01/14" in column B we would like the month that the shipment is due to automatically populate with "Jan 14" or even just "Jan". What formula can I use to achieve this?

Thanks!

Thanks Benishiryo,

Now how do I autopopulate the neighboring cell. So I could have 01/01/14 in cell A2, 07/03/13 in A3, and 02/05/14 in A4 and so on and I would want B2, B3, and B4 to autopopulate with January, July, and February OR even better Jan 14, July 13, and Feb 14. What formula can I use to achieve that?

Here is a sample file in excel. I called it fake file, but it shows what I am working with and looking to do. Thanks again!

fake file.xlsx

Attachment 276309

ok, I'll try them first

those did not help to autopopulate column B. It did help to format column A though.

Maybe I am phrasing it wrong. I think I need to list items in column B that meet the criteria in column A. The criteria in A being the date and then listing the month in column B. Hope that clarifies... hope someone can help.

Thanks!
RS

Okay, I tried the VLookUp to populate neighboring column (to populate B based on criteria in A). This was my pitiful attempt at a formula. =VLOOKUP("JAN",A2:B15,A2:B15,FALSE)

All it did was change the date in to 1/0/1900. Please help.

Okay, I'm back again. So I tried a simple formula in column B: =MONTH(A8) and it pulls out the month for the short date in the A column i.e. If A2 has 8/10/13 then B2 has 8. How do I now change B2 and subsequent rows in B to text? I feel like I'm so close!

Hope I'm clear.