pick up last value

[daveyc18]

Loading Google Sheets

I'm trying to pick up the December value for unsecured but from the last column

 

[etaf]

not sure i follow you example
Whats the last column mean - you want to return column N

you only show 1 row - which is unsecured row

the headers are NOT dates
so to lookup december

then
=INDEX(B2:N2,MATCH(A5,B1:N1,0))
with A5 = December
will return the value in december
or a grid lookup
if you wanted to lookup column A for unsecured

but as i say not following

sample xlookup.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	VARIANCE
2	Unsecured	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)
3
4
5	december
6	6557260
Sheet1

Cell Formulas
Range	Formula
A6	A6	=INDEX(B2:N2,MATCH(A5,B1:N1,0))

 

[daveyc18]

not sure i follow you example
Whats the last column mean - you want to return column N

you only show 1 row - which is unsecured row

the headers are NOT dates
so to lookup december

then
=INDEX(B2:N2,MATCH(A5,B1:N1,0))
with A5 = December
will return the value in december
or a grid lookup
if you wanted to lookup column A for unsecured

but as i say not following

sample xlookup.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	VARIANCE
2	Unsecured	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)
3
4
5	december
6	6557260
Sheet1

Cell Formulas
Range	Formula
A6	A6	=INDEX(B2:N2,MATCH(A5,B1:N1,0))

apologies yes pick up the last December value to the very right for unsecured , not the first instance which would be last year's number

 

[etaf]

can you change the headers to be dates , then you can easily do it
and still disply the headers as december

i only see 1 december in example

changed some of the months to december different years and then formatted MMMM - date shown in row4

will that work ???

sample xlookup.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	December	December	NOVEMBER	December	VARIANCE
2	Unsecured	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)
3
4									AUGUST	12/1/22	12/1/23	NOVEMBER	12/1/24	VARIANCE
5	12/1/23
6	6747323
7
Sheet1

Cell Formulas
Range	Formula
I4:N4	I4	=I1
A6	A6	=INDEX(B2:N2,MATCH(A5,B1:N1,0))

 

[daveyc18]

Loading Google Sheets

 

[etaf]

not sure wy you posted a link ???

OR if you want the last december to be found - then how about

=INDEX($B$2:$N$2,SUMPRODUCT(MAX(COLUMN($B$2:$N$2)*(A8=$B$1:$N$1))-1))

sample xlookup.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	december	december	NOVEMBER	december	VARIANCE
2	Unsecured	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)
3
4									AUGUST	december	december	NOVEMBER	december	VARIANCE
5
6
7
8	december
9	6557260
Sheet1

Cell Formulas
Range	Formula
I4:N4	I4	=I1
A9	A9	=INDEX($B$2:$N$2,SUMPRODUCT(MAX(COLUMN($B$2:$N$2)*(A8=$B$1:$N$1))-1))

 

[daveyc18]

would this be possible with xlookup?

yes, apologies, i accidentally the first december column

 

[etaf]

i'm afraid i dont know how with xlookup to get the last entry of a criteria