Formula for IF month and partial text match

[mikehk]

I have a table that has month name with text, for example :

cell A3 has date


cell A6 B6 C6 D6 E6 E6
JanPrice1 JanPrice2 FebPrice1 FebPrice2 MarPrice1 MarPrice2

the desired formula is :

IF(MONTH(A3)=1 & A6="Jan" , then "do this"


I attach a sample file.
Please help.

Thanks.

[FDibbins]

Try building this into your formula...
=TEXT(A3,"mmm")

You dont give much to go on, but that will pull a 3-letter month from a date