Matching and counting

1. I need to compare column A to column C. If a match is found then in column d, I would like to copy whatever is in column B, if no match is found then it says "no match"

2. then in column E, I would like it to count how many cells have "no match" and for it to count how many have the words "category"

I would prefer to use a formula but if i have to use a vb script or macro that should work too.


Thanks for any help.