Need help finding "Similar" Teams (I will pay anyone that can figure this out!)

[TKWSNx93]

I am comparing NBA teams and three of their stats on the road, and at home.

There are 30 teams. I am recording their Points per game at home, Points allowed at home, Pace at home, Points per game on the road, Points allowed on the road, and Pace on the road. This means a total of 6 numbers for each team.

Here is the data:

[TABLE="width: 651"]
<colgroup><col><col span="2"><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Home
[/TD]
[TD]PF[/TD]
[TD]PA
[/TD]
[TD]PACE[/TD]
[TD][/TD]
[TD]Away
[/TD]
[TD]PF[/TD]
[TD]PA[/TD]
[TD]PACE[/TD]
[/TR]
[TR]
[TD]Atlanta[/TD]
[TD]106.2[/TD]
[TD]104.3[/TD]
[TD]98.9[/TD]
[TD][/TD]
[TD]Atlanta[/TD]
[TD]96.3[/TD]
[TD]100.6[/TD]
[TD]99.2[/TD]
[/TR]
[TR]
[TD]Boston[/TD]
[TD]103.7[/TD]
[TD]103.7[/TD]
[TD]96.5[/TD]
[TD] [/TD]
[TD]Boston[/TD]
[TD]105.7[/TD]
[TD]102.7[/TD]
[TD]95.5[/TD]
[/TR]
[TR]
[TD]Brooklyn[/TD]
[TD]105.8[/TD]
[TD]112.2[/TD]
[TD]100.5[/TD]
[TD] [/TD]
[TD]Brooklyn[/TD]
[TD]106.8[/TD]
[TD]116.9[/TD]
[TD]102.9[/TD]
[/TR]
[TR]
[TD]Charlotte[/TD]
[TD]104.1[/TD]
[TD]101.4[/TD]
[TD]96.7[/TD]
[TD][/TD]
[TD]Charlotte[/TD]
[TD]105.7[/TD]
[TD]101.1[/TD]
[TD]97.2[/TD]
[/TR]
[TR]
[TD]Chicago[/TD]
[TD]105.7[/TD]
[TD]99.6[/TD]
[TD]96.2[/TD]
[TD] [/TD]
[TD]Chicago[/TD]
[TD]101[/TD]
[TD]100.1[/TD]
[TD]94.9[/TD]
[/TR]
[TR]
[TD]Cleveland[/TD]
[TD]115.2[/TD]
[TD]103.5[/TD]
[TD]96[/TD]
[TD][/TD]
[TD]Cleveland[/TD]
[TD]106[/TD]
[TD]103.6[/TD]
[TD]97.1[/TD]
[/TR]
[TR]
[TD]Dallas[/TD]
[TD]93.9[/TD]
[TD]98.1[/TD]
[TD]91.6[/TD]
[TD] [/TD]
[TD]Dallas[/TD]
[TD]92.1[/TD]
[TD]102.9[/TD]
[TD]92.6[/TD]
[/TR]
[TR]
[TD]Denver[/TD]
[TD]109.2[/TD]
[TD]112.7[/TD]
[TD]98.4[/TD]
[TD] [/TD]
[TD]Denver[/TD]
[TD]102.7[/TD]
[TD]105.3[/TD]
[TD]99.2[/TD]
[/TR]
[TR]
[TD]Detroit[/TD]
[TD]101.1[/TD]
[TD]90.1[/TD]
[TD]94.1[/TD]
[TD] [/TD]
[TD]Detroit[/TD]
[TD]98.9[/TD]
[TD]100.7[/TD]
[TD]94[/TD]
[/TR]
[TR]
[TD]Golden State[/TD]
[TD]123.9[/TD]
[TD]109.2[/TD]
[TD]99.9[/TD]
[TD] [/TD]
[TD]Golden State[/TD]
[TD]115.2[/TD]
[TD]102.6[/TD]
[TD]100.8[/TD]
[/TR]
[TR]
[TD]Houston[/TD]
[TD]111[/TD]
[TD]101.6[/TD]
[TD]97.5[/TD]
[TD] [/TD]
[TD]Houston[/TD]
[TD]112.1[/TD]
[TD]109.1[/TD]
[TD]97.6[/TD]
[/TR]
[TR]
[TD]Indiana[/TD]
[TD]103.4[/TD]
[TD]100.3[/TD]
[TD]97.6[/TD]
[TD] [/TD]
[TD]Indiana[/TD]
[TD]105.5[/TD]
[TD]115.3[/TD]
[TD]98.2[/TD]
[/TR]
[TR]
[TD]LA Clippers[/TD]
[TD]106.5[/TD]
[TD]96.5[/TD]
[TD]95.5[/TD]
[TD] [/TD]
[TD]LA Clippers[/TD]
[TD]109.9[/TD]
[TD]102.8[/TD]
[TD]96.1[/TD]
[/TR]
[TR]
[TD]LA Lakers[/TD]
[TD]109.7[/TD]
[TD]109.8[/TD]
[TD]99.2[/TD]
[TD] [/TD]
[TD]LA Lakers[/TD]
[TD]100.5[/TD]
[TD]111.5[/TD]
[TD]99.2[/TD]
[/TR]
[TR]
[TD]Memphis[/TD]
[TD]94.9[/TD]
[TD]94.3[/TD]
[TD]93.6[/TD]
[TD] [/TD]
[TD]Memphis[/TD]
[TD]100.6[/TD]
[TD]102.2[/TD]
[TD]92.6[/TD]
[/TR]
[TR]
[TD]Miami[/TD]
[TD]98.4[/TD]
[TD]100.1[/TD]
[TD]94.6[/TD]
[TD] [/TD]
[TD]Miami[/TD]
[TD]95.4[/TD]
[TD]100.5[/TD]
[TD]92.9[/TD]
[/TR]
[TR]
[TD]Milwaukee[/TD]
[TD]108.9[/TD]
[TD]104.4[/TD]
[TD]97.8[/TD]
[TD][/TD]
[TD]Milwaukee[/TD]
[TD]94.7[/TD]
[TD]98.4[/TD]
[TD]95.7[/TD]
[/TR]
[TR]
[TD]Minnesota[/TD]
[TD]104[/TD]
[TD]103.6[/TD]
[TD]94.6[/TD]
[TD][/TD]
[TD]Minnesota[/TD]
[TD]103.5
[/TD]
[TD]109.8[/TD]
[TD]95.6
[/TD]
[/TR]
[TR]
[TD]New Orleans[/TD]
[TD]107.2[/TD]
[TD]108.7[/TD]
[TD]99[/TD]
[TD] [/TD]
[TD]New Orleans[/TD]
[TD]94.5[/TD]
[TD]100.5[/TD]
[TD]96.1[/TD]
[/TR]
[TR]
[TD]New York[/TD]
[TD]105.5[/TD]
[TD]105.3[/TD]
[TD]95.8[/TD]
[TD] [/TD]
[TD]New York[/TD]
[TD]102.5[/TD]
[TD]108.9[/TD]
[TD]96.9[/TD]
[/TR]
[TR]
[TD]Oklahoma City[/TD]
[TD]109.6[/TD]
[TD]103.1[/TD]
[TD]98.8[/TD]
[TD] [/TD]
[TD]Oklahoma City[/TD]
[TD]103.1[/TD]
[TD]107.1[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]Orlando[/TD]
[TD]92[/TD]
[TD]97.6[/TD]
[TD]92.9[/TD]
[TD] [/TD]
[TD]Orlando[/TD]
[TD]95.8[/TD]
[TD]100.5[/TD]
[TD]95.6[/TD]
[/TR]
[TR]
[TD]Philadelphia[/TD]
[TD]98.8[/TD]
[TD]104.4[/TD]
[TD]97.4[/TD]
[TD][/TD]
[TD]Philadelphia[/TD]
[TD]95.4[/TD]
[TD]109.9[/TD]
[TD]95.9[/TD]
[/TR]
[TR]
[TD]Phoenix[/TD]
[TD]102.8[/TD]
[TD]110[/TD]
[TD]101.9[/TD]
[TD] [/TD]
[TD]Phoenix[/TD]
[TD]108.6[/TD]
[TD]115[/TD]
[TD]101.1[/TD]
[/TR]
[TR]
[TD]Portland[/TD]
[TD]112[/TD]
[TD]112.6[/TD]
[TD]98.1[/TD]
[TD][/TD]
[TD]Portland[/TD]
[TD]106.7[/TD]
[TD]110.5[/TD]
[TD]97.8[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[TD]103.5[/TD]
[TD]105.1[/TD]
[TD]95.8[/TD]
[TD] [/TD]
[TD]Sacramento[/TD]
[TD]102.7[/TD]
[TD]103.2[/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD]San Antonio[/TD]
[TD]95.1[/TD]
[TD]96.6[/TD]
[TD]92.8[/TD]
[TD][/TD]
[TD]San Antonio[/TD]
[TD]106.9[/TD]
[TD]98.4[/TD]
[TD]93.8[/TD]
[/TR]
[TR]
[TD]Toronto[/TD]
[TD]111.5[/TD]
[TD]99.5[/TD]
[TD]93.9[/TD]
[TD] [/TD]
[TD]Toronto[/TD]
[TD]110.3[/TD]
[TD]106.8[/TD]
[TD]96[/TD]
[/TR]
[TR]
[TD]Utah[/TD]
[TD]100.1[/TD]
[TD]94.1[/TD]
[TD]91.5[/TD]
[TD] [/TD]
[TD]Utah[/TD]
[TD]100.6[/TD]
[TD]97.8[/TD]
[TD]91.8[/TD]
[/TR]
[TR]
[TD]Washington[/TD]
[TD]105.1[/TD]
[TD]105[/TD]
[TD]97.2[/TD]
[TD] [/TD]
[TD]Washington[/TD]
[TD]101.9[/TD]
[TD]107.3[/TD]
[TD]96.2[/TD]
[/TR]
</tbody>[/TABLE]

I need the teams to have similar numbers for all three categories. For example, Minnesota and New York are very similar because the numbers for Minnesota and New York are all within 2 points. We CANNOT find the average of all three numbers and compare them. For example, a team with 111points per game is NOT similar to a team with 99points per game even if their averages are similar.

I will pay anyone that can figure this out for me. This is a project I have been doing manually for months and it's about time I find a way to automate this!

 

[TKWSNx93]

Disregard that post I made, didn't see the download link. This is a great contribution!

 

[Canapone]

Hi,

thanks for sharing feedback.

Regards


A small typo in the second formula: sorry, I'm traslating from my Italian settings PC. In the file formulas should be OK.

=IFERROR(INDEX($A$2:$A$31,AGGREGATE(15,6,ROW($2:$31)-ROW($A$2)+1/((ABS($G$2:$G$31-$G2)<2)*(ABS($H$2:$H$31-$H2)<2)*(ABS($I$2:$I$31-$I2)<2)*($A$2:$A$31<>$A2)),COLUMNS($A$1:A$1))),"")

 

[AliGW]

Here's an adaptation of Canapone's solution (L2 is a drop-down list):

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
Home	PF	PA	PACE	Away	PF	PA	PACE	Home	PF	PA	PACE	Away	PF	PA	PACE
Atlanta	Atlanta	Minnesota	Minnesota
Boston	Boston
Brooklyn	Brooklyn	New York	New York
Charlotte	Charlotte
Chicago	Chicago
Cleveland	Cleveland
Dallas	Dallas
Denver	Denver
Detroit	Detroit
Golden State	Golden State
Houston	Houston
Indiana	Indiana
LA Clippers	LA Clippers
LA Lakers	LA Lakers
Memphis	Memphis
Miami	Miami
Milwaukee	Milwaukee
Minnesota	Minnesota
New Orleans	New Orleans
New York	New York
Oklahoma City	Oklahoma City
Orlando	Orlando
Philadelphia	Philadelphia
Phoenix	Phoenix
Portland	Portland
Sacramento	Sacramento
San Antonio	San Antonio
Toronto	Toronto
Utah	Utah
Washington	Washington

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]106.2[/TD]
[TD="align: right"]104.3[/TD]
[TD="align: right"]98.9[/TD]
[TD="align: right"][/TD]

[TD="align: right"]96.3[/TD]
[TD="align: right"]100.6[/TD]
[TD="align: right"]99.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]104[/TD]
[TD="align: right"]103.6[/TD]
[TD="align: right"]94.6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]103.5[/TD]
[TD="align: right"]109.8[/TD]
[TD="align: right"]95.6[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]103.7[/TD]
[TD="align: right"]103.7[/TD]
[TD="align: right"]96.5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]105.7[/TD]
[TD="align: right"]102.7[/TD]
[TD="align: right"]95.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]105.8[/TD]
[TD="align: right"]112.2[/TD]
[TD="align: right"]100.5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]106.8[/TD]
[TD="align: right"]116.9[/TD]
[TD="align: right"]102.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]105.5[/TD]
[TD="align: right"]105.3[/TD]
[TD="align: right"]95.8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]102.5[/TD]
[TD="align: right"]108.9[/TD]
[TD="align: right"]96.9[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]104.1[/TD]
[TD="align: right"]101.4[/TD]
[TD="align: right"]96.7[/TD]
[TD="align: right"][/TD]

[TD="align: right"]105.7[/TD]
[TD="align: right"]101.1[/TD]
[TD="align: right"]97.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]105.7[/TD]
[TD="align: right"]99.6[/TD]
[TD="align: right"]96.2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]101[/TD]
[TD="align: right"]100.1[/TD]
[TD="align: right"]94.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]115.2[/TD]
[TD="align: right"]103.5[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"][/TD]

[TD="align: right"]106[/TD]
[TD="align: right"]103.6[/TD]
[TD="align: right"]97.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]93.9[/TD]
[TD="align: right"]98.1[/TD]
[TD="align: right"]91.6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]92.1[/TD]
[TD="align: right"]102.9[/TD]
[TD="align: right"]92.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]109.2[/TD]
[TD="align: right"]112.7[/TD]
[TD="align: right"]98.4[/TD]
[TD="align: right"][/TD]

[TD="align: right"]102.7[/TD]
[TD="align: right"]105.3[/TD]
[TD="align: right"]99.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]101.1[/TD]
[TD="align: right"]90.1[/TD]
[TD="align: right"]94.1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]98.9[/TD]
[TD="align: right"]100.7[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]123.9[/TD]
[TD="align: right"]109.2[/TD]
[TD="align: right"]99.9[/TD]
[TD="align: right"][/TD]

[TD="align: right"]115.2[/TD]
[TD="align: right"]102.6[/TD]
[TD="align: right"]100.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]111[/TD]
[TD="align: right"]101.6[/TD]
[TD="align: right"]97.5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]112.1[/TD]
[TD="align: right"]109.1[/TD]
[TD="align: right"]97.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]103.4[/TD]
[TD="align: right"]100.3[/TD]
[TD="align: right"]97.6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]105.5[/TD]
[TD="align: right"]115.3[/TD]
[TD="align: right"]98.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]106.5[/TD]
[TD="align: right"]96.5[/TD]
[TD="align: right"]95.5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]109.9[/TD]
[TD="align: right"]102.8[/TD]
[TD="align: right"]96.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]109.7[/TD]
[TD="align: right"]109.8[/TD]
[TD="align: right"]99.2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]100.5[/TD]
[TD="align: right"]111.5[/TD]
[TD="align: right"]99.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]94.9[/TD]
[TD="align: right"]94.3[/TD]
[TD="align: right"]93.6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]100.6[/TD]
[TD="align: right"]102.2[/TD]
[TD="align: right"]92.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]98.4[/TD]
[TD="align: right"]100.1[/TD]
[TD="align: right"]94.6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]95.4[/TD]
[TD="align: right"]100.5[/TD]
[TD="align: right"]92.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]108.9[/TD]
[TD="align: right"]104.4[/TD]
[TD="align: right"]97.8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]94.7[/TD]
[TD="align: right"]98.4[/TD]
[TD="align: right"]95.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]104[/TD]
[TD="align: right"]103.6[/TD]
[TD="align: right"]94.6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]103.5[/TD]
[TD="align: right"]109.8[/TD]
[TD="align: right"]95.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]107.2[/TD]
[TD="align: right"]108.7[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"][/TD]

[TD="align: right"]94.5[/TD]
[TD="align: right"]100.5[/TD]
[TD="align: right"]96.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]105.5[/TD]
[TD="align: right"]105.3[/TD]
[TD="align: right"]95.8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]102.5[/TD]
[TD="align: right"]108.9[/TD]
[TD="align: right"]96.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"]109.6[/TD]
[TD="align: right"]103.1[/TD]
[TD="align: right"]98.8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]103.1[/TD]
[TD="align: right"]107.1[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]97.6[/TD]
[TD="align: right"]92.9[/TD]
[TD="align: right"][/TD]

[TD="align: right"]95.8[/TD]
[TD="align: right"]100.5[/TD]
[TD="align: right"]95.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"]98.8[/TD]
[TD="align: right"]104.4[/TD]
[TD="align: right"]97.4[/TD]
[TD="align: right"][/TD]

[TD="align: right"]95.4[/TD]
[TD="align: right"]109.9[/TD]
[TD="align: right"]95.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"]102.8[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]101.9[/TD]
[TD="align: right"][/TD]

[TD="align: right"]108.6[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]101.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"]112[/TD]
[TD="align: right"]112.6[/TD]
[TD="align: right"]98.1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]106.7[/TD]
[TD="align: right"]110.5[/TD]
[TD="align: right"]97.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"]103.5[/TD]
[TD="align: right"]105.1[/TD]
[TD="align: right"]95.8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]102.7[/TD]
[TD="align: right"]103.2[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"]95.1[/TD]
[TD="align: right"]96.6[/TD]
[TD="align: right"]92.8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]106.9[/TD]
[TD="align: right"]98.4[/TD]
[TD="align: right"]93.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]

[TD="align: right"]111.5[/TD]
[TD="align: right"]99.5[/TD]
[TD="align: right"]93.9[/TD]
[TD="align: right"][/TD]

[TD="align: right"]110.3[/TD]
[TD="align: right"]106.8[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]100.1[/TD]
[TD="align: right"]94.1[/TD]
[TD="align: right"]91.5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]100.6[/TD]
[TD="align: right"]97.8[/TD]
[TD="align: right"]91.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"]105.1[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]97.2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]101.9[/TD]
[TD="align: right"]107.3[/TD]
[TD="align: right"]96.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M2[/TH]
[TD="align: left"]=INDEX($B$2:$D$31,MATCH($L2,$A$2:$A$31,0),MATCH(M1,$B$1:$D$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]N2[/TH]
[TD="align: left"]=INDEX($B$2:$D$31,MATCH($L2,$A$2:$A$31,0),MATCH(N1,$B$1:$D$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]O2[/TH]
[TD="align: left"]=INDEX($B$2:$D$31,MATCH($L2,$A$2:$A$31,0),MATCH(O1,$B$1:$D$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q2[/TH]
[TD="align: left"]=L2[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R2[/TH]
[TD="align: left"]=INDEX($G$2:$I$31,MATCH($L2,$A$2:$A$31,0),MATCH(R1,$G$1:$I$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]S2[/TH]
[TD="align: left"]=INDEX($G$2:$I$31,MATCH($L2,$A$2:$A$31,0),MATCH(S1,$G$1:$I$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]T2[/TH]
[TD="align: left"]=INDEX($G$2:$I$31,MATCH($L2,$A$2:$A$31,0),MATCH(T1,$G$1:$I$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q4[/TH]
[TD="align: left"]=L4[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R4[/TH]
[TD="align: left"]=IFERROR(INDEX($G$2:$I$31,MATCH($L4,$A$2:$A$31,0),MATCH(R$1,$G$1:$I$1,0)),"")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]S4[/TH]
[TD="align: left"]=IFERROR(INDEX($G$2:$I$31,MATCH($L4,$A$2:$A$31,0),MATCH(S$1,$G$1:$I$1,0)),"")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]T4[/TH]
[TD="align: left"]=IFERROR(INDEX($G$2:$I$31,MATCH($L4,$A$2:$A$31,0),MATCH(T$1,$G$1:$I$1,0)),"")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]M4[/TH]
[TD="align: left"]=IFERROR(INDEX($B$2:$D$31,MATCH($L4,$A$2:$A$31,0),MATCH(M$1,$B$1:$D$1,0)),"")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]N4[/TH]
[TD="align: left"]=IFERROR(INDEX($B$2:$D$31,MATCH($L4,$A$2:$A$31,0),MATCH(N$1,$B$1:$D$1,0)),"")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]O4[/TH]
[TD="align: left"]=IFERROR(INDEX($B$2:$D$31,MATCH($L4,$A$2:$A$31,0),MATCH(O$1,$B$1:$D$1,0)),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L4[/TH]
[TD="align: left"]{=IFERROR(INDEX($A$2:$A$31,AGGREGATE(15,6,ROW($2:$31)-ROW($A$2)+1/((ABS($B$2:$B$31-$M$2)<=2)*(ABS($C$2:$C$31-$N$2)<=2)*(ABS($D$2:$D$31-$O$2)<=2)*(ABS($G$2:$G$31-$R$2)<=2)*(ABS($H$2:$H$31-$S$2)<=2)*(ABS($I$2:$I$31-$T$2)<=2)*($A$2:$A$31<>$L$2)),ROWS($A$1:A1))),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]