I’m creating a fantasy football spreadsheet and I’m looking to use double xlookup to return data based on two criteria.

I lookup the values in “sheet 1” column B in “sheet 2” column A and then lookup the values in “sheet 2” row 2 in “sheet 3” column A and finally return the values in “sheet 3” column C.

Value is returned on sheet 1 column c “average porj points”

I tried

=XLOOKUP(B3,'Sheet2!'A2:A,XLOOKUP('sheet2!'B2,'sheet3'!A4:A35,'sheet3'!C4:C35)

It returned an error

Array arguments to XLOOKUP are of different size

I’m looking to return a value for “Josh Allen” so I lookup “Buf” in “sheet 2” which would be “A5” “sheet 2” and then look up the first corresponding team name “B5” (NJY) in “sheet 3” which should return 15.28. The end result should be the average of the corresponding numbers from every team that Josh Allen plays (NYJ LV WSH MIA JAX NYG NE TB CIN DEN NYJ)