Look up todays date in a column and return the row number to another cell

[coastalkidd]

Hey!

I'm having some issues with a spreadsheet i am trying to create.

I need to do a look up for todays date in a column and return the same number as the row back to a cell on the same line.

 

[SanjayGMusafir]

Hey!

I'm having some issues with a spreadsheet i am trying to create.

I need to do a look up for todays date in a column and return the same number as the row back to a cell on the same line.

Assuming you want to look up in Column A

=MATCH(TODAY(),INDEX(A:A,0,1),0)

 

[Peter_SSs]

Welcome to the MrExcel board!

look up for todays date in a column and return the same number as the row

From your image it looks more like you might want to look for today's date in a row and return the number of the column.

Could it be this that you are looking for?

23 12 18.xlsm
	A	B	C	D	E	F	G	H
1	Today's column number			14/12/2023	15/12/2023	18/12/2023	19/12/2023	20/12/2023
2	6
Lookup Today

Cell Formulas
Range	Formula
A2	A2	=MATCH(TODAY(),1:1,0)

If not please give a fuller explanation, sample data and expected result (preferably with XL2BB not just an image)

BTW, I have modified your thread title. See #14 of the Forum Rules regarding the use of all upper case in titles or posts.

@SanjayGMusafir
INDEX(A:A,0,1)
is the same as just
A:A

 

[Fluff]

My take on this

Fluff.xlsm
	A	B	C	D
1		15/12/2023	18/12/2023	19/12/2023
2	81	90	81	12
3	4	32	4	66
4	42	83	42	9
5	38	55	38	93
6	99	25	99	97
Sheet5

Cell Formulas
Range	Formula
A2:A6	A2	=XLOOKUP(TODAY(),$B$1:$D$1,B2:D2,"")

 

[Peter_SSs]

My take on this

Could well be right. If so, then maybe FILTER to get them all at once.

23 12 18.xlsm
	A	B	C	D
1	Today	15/12/2023	18/12/2023	19/12/2023
2	81	90	81	12
3	4	32	4	66
4	42	83	42	9
5	38	55	38	93
6	99	25	99	97
Lookup Today (2)

Cell Formulas
Range	Formula
A2:A6	A2	=FILTER(B2:D6,B1:D1=TODAY(),"")
Dynamic array formulas.