I am looking at the worksheet  function you provided. My problem is
that you are so far ahead of me that I am not able to translate your
formula into something that I understand and the techniques of which I
can use in my efforts down the road . . .

Since I have spent several days trying to solve the problem with VBA,
I really want to use that method rather than a worksheet function
which goes haywire when I change the layout (which happens
frequently). Also, to be honest, I have become somewhat obsessed with
the notion that there MUST be a way to use Autofilter in VBA to
accomplish my goal . . .am I mistaken?

If Autofilter absolutely cannot be used as I desire, I have already
written a VBA macro which accomplishes my goal in a very amateurish
fashion, moving up the "team" column one record  at a time until it
finds a "match", then recording the WIN/LOSS in a variable and moving
on up the line.

Thanks for the formula you provided, though--when I get some free time
I need to learn how to use some of these worksheet functions, and your
formula will be a great practice model!