table.jpg

Please see the attached image for the chart.

i need to get the col C formulated.

So in col C i need if A2=ACC01 and B2=22400 then C2=CR
If A2= ACC01 and B2 = 52000 then C2 = DR
If A2 = PI and B2 = 22400 then C2 = DR
if A2 = PI and B2 = 52000 then C2 = NA
if error = N/A

I hope it made sense

Cheers!!
table.jpg