Lookup column name based on max value within a defined time period

[Lilium]

I have a table "Data" which contains different temperatures recorded by sensors and the time at which a sensor registered the temperature.
Sensor names can be found in row 1 as from column C. Times are in column A.
I would like to find the sensor (name) from row 1 that registered the max temperature during a defined period. The period is defined in tha Analysis tab on cell B2 and C2. The sensor name should be mentioned on B5 of the Analysis tab.
The defined period is mentioned in the tab Analysis.
I've been searching with vlookup but I can't seem to find something that works, I just don't see it.
Any input is much appreciated.

I've included the screenshots.

 

[Legacy 143009]

At 09:37, both sensors 003 and 005 has the maximum value of 20.6. Which one to choose?

 

[awoohaw]

Here is a fairly old school way of doing it. It requires that there is only ONE value to match in the given range (so the 20.7 in first row is not selected because it is not in the time range requested).
It can probably be done much easier with some Excel 365 functions. I'm not sure what Excel 2019 functions are available.

Mr Excel Questions 73.xlsm
	A	B	C	D	E	F	G
1	Data
2	Time	Point	2202-001	2202-002	2202-003	2202-004	2202-005
3	09:35	1	20.4	19.9	20.7	20.1	20.8
4	09:36	2	20.4	19.9	20.6	20	20.7
5	09:37	3	20.4	19.8	20.6	19.9	20.6
6	09:38	4	20.3	19.8	20.5	19.8	20.5
7	09:39	5	20.3	19.7	20.4	19.8	20.4
8
9
10		Period Beg	Period End
11		09:36	09:38
12
13		Sensor Name
14	Hotest Temp in Period	2202-005
Sheet5

Cell Formulas
Range	Formula
B14	B14	=INDEX($C$2:$G$2,SUM((MAX(($B$11<=$A$3:$A$7)*($C$11>=$A$3:$A$7)*($C$3:$G$7))=($C$3:$G$7))* ($B$11<=$A$3:$A$7)*($C$11>=$A$3:$A$7)*(COLUMN($C$2:$G$2)-COLUMN($B$2))))

 

[Lilium]

At 09:37, both sensors 003 and 005 has the maximum value of 20.6. Which one to choose?

Both, or all of them if there would be more than 2

 

[Lilium]

Here is a fairly old school way of doing it. It requires that there is only ONE value to match in the given range (so the 20.7 in first row is not selected because it is not in the time range requested).
It can probably be done much easier with some Excel 365 functions. I'm not sure what Excel 2019 functions are available.

Mr Excel Questions 73.xlsm
	A	B	C	D	E	F	G
1	Data
2	Time	Point	2202-001	2202-002	2202-003	2202-004	2202-005
3	09:35	1	20.4	19.9	20.7	20.1	20.8
4	09:36	2	20.4	19.9	20.6	20	20.7
5	09:37	3	20.4	19.8	20.6	19.9	20.6
6	09:38	4	20.3	19.8	20.5	19.8	20.5
7	09:39	5	20.3	19.7	20.4	19.8	20.4
8
9
10		Period Beg	Period End
11		09:36	09:38
12
13		Sensor Name
14	Hotest Temp in Period	2202-005
Sheet5

Cell Formulas
Range	Formula
B14	B14	=INDEX($C$2:$G$2,SUM((MAX(($B$11<=$A$3:$A$7)*($C$11>=$A$3:$A$7)*($C$3:$G$7))=($C$3:$G$7))* ($B$11<=$A$3:$A$7)*($C$11>=$A$3:$A$7)*(COLUMN($C$2:$G$2)-COLUMN($B$2))))

Thank you Awoohaw.
I forgot to mention (see flashbond's reponse), I would like to see all sensor names if more than 1 sensor in the given timeframe has the same max value.

 

[Peter_SSs]

You could try this but note that a sensor will get listed more than once if it has the equal top value in the range more than once - see second example below.

Lilium.xlsm
	A	B	C	D	E	F	G
1	Time	Point	2202-001	2202-002	2202-003	2202-004	2202-005
2	9:35	1	20.4	19.9	20.7	20.1	20.8
3	9:36	2	20.4	19.9	20.6	20	20.7
4	9:37	3	20.4	19.8	20.6	19.9	20.6
5	9:38	4	20.3	19.8	20.5	19.8	20.5
6	9:39	5	20.3	19.7	20.4	19.8	20.6
Data

Check your table name and table headers in the formula below.

Lilium.xlsm
	B	C	D
1	Begin	End	Hottest Sensors
2	9:36	9:38	2202-005
3	9:37	9:39	2202-003,2202-005,2202-005
Analysis

Cell Formulas
Range	Formula
D2:D3	D2	=TEXTJOIN(",",1,IF((Table1[Time]<=C2)*(Table1[Time]>=B2)*(Table1[[2202-001]:[2202-005]]=MAX(IF(Table1[Time]>=B2,IF(Table1[Time]<=C2,Table1[[2202-001]:[2202-005]])))),Table1[[#Headers],[2202-001]:[2202-005]],""))