Need help with formula

[bhandari]

Name jan feb march apr may june jack 1 2 3 4 5 6 sally 7 8 9 10 11 12 Girish 13 14 15 16 17 18 wen 19 20 21 22 23 24 <tbody> </tbody>

<colgroup><col width="64" span="7" style="width:48pt"></colgroup><tbody>
</tbody>

Name	Jan to june
sally	MATCH(A10,B1:G1,0),VLOOKUP(A9,A1:G5,{2,3,4,5,6,7},FALSE)
col Number{2,3,4,5,6,7	if i give any column number i have to get that valuefor that name

<tbody>
</tbody>

I need help with this formula

 

[oldbrewer]

Name	jan	feb	march	apr	may	june
jack	1	2	3	4	5	6
sally	7	8	9	10	11	12
Girish	13	14	15	16	17	18
wen	19	20	21	22	23	24
							answer
				name	month		17
				Girish	may
			formula
			=OFFSET($A$1,MATCH($E$17,$A$2:$A$5,0),MATCH($F$17,$B$1:$G$1,0))

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Fluff]

Another option

Excel 2013/2016
	A	B	C	D	E	F	G
1	Name	jan	feb	march	apr	may	june
2	jack	1	2	3	4	5	6
3	sally	7	8	9	10	11	12
4	Girish	13	14	15	16	17	18
5	wen	19	20	21	22	23	24
6
7
8		sally
9		may
10		11
Sheet2

Cell Formulas
Range	Formula
B10	=INDEX(A1:G5,MATCH(B8,A1:A5,0),MATCH(B9,A1:G1,0))