Which formula can I use to replace data based on various criteria?

I have the following data set (Data set 1)

Team 1	s	s	Team 2
Team 3	s	s	Team 4
Team 5	s	s	Team 6
Team 7	s	s	Team 8

I have another data set (Data set 2), with a few results in it,

Team 1	4	2	Team 2
Team 7	1	0	Team 8

I want to automatically replace the scores from data set 2 into data set 1. For those that don't match up, it should just say "s"

I have about 200-300 results and 500 fixtures to do it manually.

What version of Excel does this have to work in?

One way...

Data Range

	A	B	C	D
1	Team 1	4	2	Team 2
2	Team 3	s	s	Team 4
3	Team 5	s	s	Team 6
4	Team 7	1	0	Team 8
5	------	------	------	------
6
7	Team 1	4	2	Team 2
8	Team 7	1	0	Team 8

This array formula** entered in B1:

=IFERROR(IF(MATCH($A1,$A$7:$A$8,0)=MATCH($D1,$D$7:$D$8,0),INDEX(B$7:B$8,MATCH(1,($A$7:$A$8=$A1)*($D$7:$D$8=$D1),0)),1/0),"s")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to C1 then down as needed.

Can you post a SMALL sample file and show us what result you expect?

A SMALL file will have about 20 rows worth of data.

Good deal. Thanks for the feedback!