Need help with an IF/THEN formula to include AND in addition to a date lookup

[Trinkit]

I am new to this forum, so I apologize if this question has already been addressed. Here is what I am attempting to do:

IF the content of cell "A" AND the date (the year only) in cell "B"
THEN
the content of cell "C" is inserted into cell "D".

An example:
"B" "A" "C" "D"
5/10/2019 Med $10.00

The date is formated to read 10May19

Thank you so much for any and all assistance.

 

[most]

I not sure that I compute your example, but this might help you.
It will check if the year in column B is same as the year column A and then copy text from C to D.

Sub doit()
 For Each c In Range("B2:B50") 'Change to last row
    If Year(c) = Year(c.Offset(0, -1)) Then c.Offset(0, 2).Value = c.Offset(0, 1).Value
 Next c
End Sub

 

[Trinkit]

It appears that when I posted my example, things got a little disoriented. Let me try to explain a little better: "B" is the date (5/10/2019); "A" is the text "Med"; "C" is currency "$10.00" and "D" was a blank cell where I wanted the formula to calculated.

 

[Fluff]

Hi & welcome to MrExcel.
Can you explain what you mean by

IF the content of cell "A" AND the date (the year only) in cell "B"

 

[Excelnewie]

Is it based on any conditions? For example do you want the content of cell C to be put into cell D only if the cell B is "Med" AND cell A is 2019, and not another word/date?

 

[Trinkit]

yes, that is exactly what I want - the amount needs to be put into cell D ONLY if the other 2 conditions are met

 

[Fluff]

How about
=IF(AND(YEAR(A1)=2019,B1="Med"),C1,"")

 

[Trinkit]

That worked!!!! Thank you SOOOOOOOOOOOO much!

 

[Fluff]

You're welcome & thanks for the feedback