Dynamic Offset?

[putzhead]

I have a sheet that has salespeople names in column C. Columns D-O have the months of the year and this is filled with sales data. I am able to use Large and Offset in cell B2 to give me the largest sales number is a given month. My problem is how can I write a formula in A2 to give me the salesperson name related to that particular sales number?

tia

 

[Fluff]

What version of Excel are you using?
please update your account details to show this, as it affects which functions you can use.

 

[putzhead]

Hi, sorry, on Excel 2013. I have updated my account as well

 

[Fluff]

Ok, thanks for that, how about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		01/03/2020
2	Bill Brewer	718
3
4
5				01/01/2020	01/02/2020	01/03/2020	01/04/2020	01/05/2020	01/06/2020	01/07/2020	01/08/2020	01/09/2020	01/10/2020	01/11/2020	01/12/2020
6			Tom Pearce	396	385	290	781	416	895	320	364	642	231	764	300
7			Bill Brewer	391	586	718	381	803	413	612	188	931	388	612	503
8			Jan Stewer	159	622	325	494	552	556	989	406	870	755	338	832
9			Peter Gurney	457	227	644	834	272	793	794	170	395	739	860	100
10			Peter Davy	666	187	566	689	933	899	255	211	421	603	732	739
11			Dan'l Whiddon	835	971	524	834	784	986	460	310	658	480	397	578
12			Harry Hawke	765	421	216	309	649	210	918	936	339	279	371	226
13			Tom Cobley	381	528	326	915	275	349	252	685	289	329	867	356
Master

Cell Formulas
Range	Formula
A2	A2	=INDEX(C6:C13,MATCH(B2,INDEX(D6:O13,,MATCH(B1,D5:O5,0)),0))
B2	B2	=MAX(INDEX(D6:O13,,MATCH(B1,D5:O5,0)))
D5:O5	D5	=DATE(2020,SEQUENCE(,12),1)
D6:O13	D6	=RANDARRAY(8,12,100,1000,1)
Dynamic array formulas.

Ignore the D5 & D6 formula, they were just to set-up some test data.

 

[putzhead]

perfect, thanks!!!

 

[Fluff]

You're welcome & thanks for the feedback.