IF, AND OR combination

Hi all,

I am trying to combine if function with two rules for thousands of rows that i cannot go through manually every time i run report and have updates.

i need a date value from a one cell to be copied IF first cell value is "A4" out of 5 different variations and second cell is either A, B or C value out of 5
variations and a blank.

I was trying to use formula =IF(AND(A2="A4",OR(B2="B","C","A"),C2) but it gives me error and i am not sure what i am doing wrong.

Please see attached example with manually calculated results.

Thank you,
Lina Va

Thank you very much for your help, Alan

That function is wonderful! Works like a charm.