... I looked at the LOOKUP &
VLOOKUP function, but don't think that's what I want. ...

Maybe COUNTIF() and SUMIF() are a better fit here.