return value in header row

[neilp]

Hi

I have a table of data (D4:AI29). Row 4 is a header row that contains the numbers 1 - 32.
In each row below the header, the letter "S" appears. I'm looking for a formula I can place in AK5 that will tell me the number in the header row that corresponds to where the S is in that row. I would then like to copy the formula down AK so it works for all rows.

Does that make any sense. I was sensing Index - Match might be the way forward, but cant get it to output anything meaningful

Thanks in advance

Neil

 

[AlanY]

a cut-down version of your data

Book1
	C	D	E	F	G	H	I	J
3
4		1	2	3	4	5	6
5						S		5
6			S					2
7
8					S			4
9
10				S				3
11
12							S	6
13
14
15
Sheet1

Cell Formulas
Range	Formula
J5	=IFERROR(INDEX($D$4:$I$4,MATCH("S",D5:I5,0)),"")

 

[neilp]

Alan

That's perfect - thanks so much

Neil

 

[AlanY]

you're welcome