Mock Draft Accuracy Functions

[nkavs1233]

I need help figuring out what function to use in order to assess the accuracy of a mock draft based on a point system I found online. I created 2 sheets: Sheet 1= which contains the actual results of the upcoming NFL Draft (which I will update as picks are made) and Sheet 2= the predicted results. On both sheets, the columns are as follows: Column A is "Pick Number", Column B is "Team", and Column C is "Player". I want to assess if I correctly predicted that a certain team (column B) would select a player (column C), doing so would net me 3 points. What function can I use that will detect a correctly predicted B:C sequence? For example, if on sheet 2 I predict that the Bengals select Joe Burrow and this prediction is correct, how can I create a function that recognizes this?

I tried using =if, =and, =match, and =vlookup functions but had no luck.

Thanks!

 

[AhoyNC]

Maybe something like this:

Sheet2

Book1
	A	B	C	D
1	Pick #	Team	Player	Points
2	3	Team1	Player4	0
3	1	Team2	Player1	3
4	5	Team1	Player7	0
5	6	Team4	Player10	3
6	4	Team2	Player8	0
7	2	Team6	Player9	3
Sheet2

Cell Formulas
Range	Formula
D2:D7	D2	=IF(ISNUMBER(AGGREGATE(15,6,(ROW(Sheet1!$B$2:$B$7)-ROW(Sheet1!$B$2)+1)/(B2&C2=(Sheet1!$B$2:$B$7&Sheet1!$C$2:$C$7)),1)),3,0)

Sheet1

Book1
	A	B	C
1	Pick #	Team	Player
2	1	Team2	Player1
3	3	Team4	Player2
4	5	Team1	Player8
5	4	Team2	Player12
6	2	Team6	Player9
7	6	Team4	Player10
Sheet1