IF AND function with a condition where a range is equal to a text value

Hello!

I'm sorry if my title doesn't make any sense - I don't exactly know how to explain what I'm trying to do. But basically, you know how if you do a SUMIF function, you can say "for any row in range XX:XX where a cell is equal to "text", add up range YY:YY" (ex: =SUMIF($B$4:$B$679,"Corn",CC4:CC678)? I want to do a similar thing with IF AND, but with another condition and without the adding. So in normal terms I would want "if DA4 matches $A$4:$A$678, AND $B$4:$B$678 shows the word "Corn" then return "M"" THIS IS THE FUNCTION I'M USING =IF(AND(MATCH(DA4,$A$4:$A$678),($B$4:$B$678,"Corn","")),"M","")

The first part (the MATCH part) works fine, but it's the part after that that's having trouble. I'm doing it like this $B$4:$B$678,"Corn","" instead of like this $B$4:$B$678="Corn", because the SUMIF function does it with commas. But I also tried it with and equal sign and it still didn't work.

I hope some of this makes sense. I really appreciate the help!

See the yellow banner at the top of the screen.