get column header from a range of sequential numbers

[Paragons]

I have tried iterations of lookup, index and match to no avail.
Column header j is from 1 to 31 then f is from 32 to 59 then m is 60 to 90 and a is from 91 to 120 etc (others are not displayed, you can guess that they are months)
A random d100 number is generated such as 32 and this would fall in the range 32 to 59 which is column header f.
The second row d100 of 77 is in the range 56 to 90 which is column header m

So what is the formula to get the result?

Thanks in advance,

Pete

Pl#	j	f	m	a	d100	result
1	31	59	90	120	32	f
2	25	55	90	120	77	m

 

[Paragons]

I think I got it with lookup and offset

 

[KOKOSEK]

I am not sure that columns are important. If we know that headers are first letter of months, so maybe you can try put into result cell:

=LOWER(LEFT(TEXT("1/1/2023"+F2-1,"mmm"),1))

where F2 is a cell where d100 is placed.

 

[Peter_SSs]

I think I got it with lookup and offset

OFFSET is a volatile function so I would avoid that if possible. Would this non-volatile version work for you?

23 05 29.xlsm
	A	B	C	D	E	F	G
1	Pl#	j	f	m	a	d100	result
2	1	31	59	90	120	32	f
3	2	25	55	90	120	77	m
4	3	25	55	90	120	16	j
Header range

Cell Formulas
Range	Formula
G2:G4	G2	=IFNA(LOOKUP(F2-1,B2:D2,C$1:E$1),B$1)

 

[Paragons]

Thank you all for the solutions.

Pete

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.