Using HLOOKUP with merged cells

[ATSJ]

I have a table where the header row is three merged cells and there are multiple columns below corresponding to that title. What I need is a formula that looks up (presumably using HLOOKUP) the name, before then finding the maximum value on any row below.

Person A

Person B

<tbody>
</tbody>

1	2	3	4	5	6
7	8	9	10	11	12
13	14	15	16	17	18
19	20	21	22	23	24

<tbody>
</tbody>

So a search for Person B looking for the maximum value on row 3 would return the value 12.

OR

a search for Person A, finding the max value for them on row 5 would return the value 21.

Any help is appreciated.

 

[FDibbins]

If your sample really is that simple...

	G​	H​	I​	J​	K​	L​
1​	Person A​	​	​	Person B​	​	​
2​	1	2	3	4	5	6
3​	7	8	9	10	11	12
4​	13	14	15	16	17	18
5​	19	20	21	22	23	24
6​
7​	Person	b	Row	3	Max	12​

L7=MAX(OFFSET($G$1,$J$7-1,MATCH($G$7&" "&$H$7,$G$1:$L$1,0)-1,1,3))