lookup but second match

[daveyc18]

let's say I wanna do a lookip based on beta but I want the second December result

currently I'm manually deleting column b every month since vlookup and match returns the first result (my match is based on the month)

 

[daveyc18]

Loading Google Sheets

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	DECEMBER 2022 -DECEMBER 2023
2		DECEMBER	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	VARIANCE
3	alpha	2,425,492	0	0	0	9,102,771	0	4,962,717	0	0	0	0	54,741	0	-54,741
4	beta	5,363,536	5,498,576	5,405,138	5,268,360	6,110,111	5,407,717	8,799,466	7,112,469	6,671,196	6,440,093	6,747,323	6,823,022	6,557,260	-265,762
5	gamma	1,958,420	2,203,353	2,424,687	4,211,700	1,117,432	1,091,312	4,558,734	4,256,906	1,271,846	30,402,050	6,608,454	2,107,233	3,379,503	1,272,270
6
7
8
9
10	Find	6,557,260
11	beta
12	Month
13	December
14
15
Sheet1

Cell Formulas
Range	Formula
B10	B10	=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),AGGREGATE(14,6,(COLUMN($B$2:$O$2)-COLUMN($B$2)+1)/($B$2:$O$2=$A$13),1))

 

[daveyc18]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	DECEMBER 2022 -DECEMBER 2023
2		DECEMBER	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	VARIANCE
3	alpha	2,425,492	0	0	0	9,102,771	0	4,962,717	0	0	0	0	54,741	0	-54,741
4	beta	5,363,536	5,498,576	5,405,138	5,268,360	6,110,111	5,407,717	8,799,466	7,112,469	6,671,196	6,440,093	6,747,323	6,823,022	6,557,260	-265,762
5	gamma	1,958,420	2,203,353	2,424,687	4,211,700	1,117,432	1,091,312	4,558,734	4,256,906	1,271,846	30,402,050	6,608,454	2,107,233	3,379,503	1,272,270
6
7
8
9
10	Find	6,557,260
11	beta
12	Month
13	December
14
15
Sheet1

Cell Formulas
Range	Formula
B10	B10	=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),AGGREGATE(14,6,(COLUMN($B$2:$O$2)-COLUMN($B$2)+1)/($B$2:$O$2=$A$13),1))

mad excel skills

maybe I'll just delete column ;B lol

 

[AhoyNC]

With Excel 365 you could also use:
=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),XMATCH($A$13,B2:O2,,-1))

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	DECEMBER 2022 -DECEMBER 2023
2		DECEMBER	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	VARIANCE
3	alpha	2,425,492	0	0	0	9,102,771	0	4,962,717	0	0	0	0	54,741	0	-54,741
4	beta	5,363,536	5,498,576	5,405,138	5,268,360	6,110,111	5,407,717	8,799,466	7,112,469	6,671,196	6,440,093	6,747,323	6,823,022	6,557,260	-265,762
5	gamma	1,958,420	2,203,353	2,424,687	4,211,700	1,117,432	1,091,312	4,558,734	4,256,906	1,271,846	30,402,050	6,608,454	2,107,233	3,379,503	1,272,270
6
7
8
9		Excel 2010		Excel 365
10	Find	6,557,260		6,557,260
11	beta
12	Month
13	DECEMBER
Sheet1

Cell Formulas
Range	Formula
B10	B10	=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),AGGREGATE(14,6,(COLUMN($B$2:$O$2)-COLUMN($B$2)+1)/($B$2:$O$2=$A$13),1))
D10	D10	=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),XMATCH($A$13,B2:O2,,-1))

 

[daveyc18]

With Excel 365 you could also use:
=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),XMATCH($A$13,B2:O2,,-1))

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	DECEMBER 2022 -DECEMBER 2023
2		DECEMBER	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	VARIANCE
3	alpha	2,425,492	0	0	0	9,102,771	0	4,962,717	0	0	0	0	54,741	0	-54,741
4	beta	5,363,536	5,498,576	5,405,138	5,268,360	6,110,111	5,407,717	8,799,466	7,112,469	6,671,196	6,440,093	6,747,323	6,823,022	6,557,260	-265,762
5	gamma	1,958,420	2,203,353	2,424,687	4,211,700	1,117,432	1,091,312	4,558,734	4,256,906	1,271,846	30,402,050	6,608,454	2,107,233	3,379,503	1,272,270
6
7
8
9		Excel 2010		Excel 365
10	Find	6,557,260		6,557,260
11	beta
12	Month
13	DECEMBER
Sheet1

Cell Formulas
Range	Formula
B10	B10	=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),AGGREGATE(14,6,(COLUMN($B$2:$O$2)-COLUMN($B$2)+1)/($B$2:$O$2=$A$13),1))
D10	D10	=INDEX($B$3:$O$5,MATCH($A$11,$A$3:$A$5,0),XMATCH($A$13,B2:O2,,-1))

htis is why i never tell people im "advanced" in excel