Looking to pull multiple cells from one row based on today's date

[m1982j]

Hi,

I have a sheet which uses the first row as a calendar of sorts, a bit like the following...

Please Login or Register  to view this content.

I'm looking to be able to pull all REFs for the current day and for that to dynamically update every day.
What I'd like it to look like is:

Jobs for today: "<---assuming today was 01/02/2022 in this example"
REF3
REF4
REF5
REF6


I have tried using the today function along with HLOOKUP but thus far I have had zero luck.

Is anybody able to help? Thanks
As simple as possible ideally as I am not overly advanced in Excel.

[Pete_UK]

Welcome to the forum.

It would help if you attached a sample Excel workbook, and you can do this by following the details in the yellow banner at the top of the screen.

Hope this helps.

Pete

[m1982j]

Attached a sample of my file, thank you

[Pete_UK]

You can use this formula in B20:

=INDEX($C$2:$P$18,ROWS($1:1),MATCH(TODAY(),$C$1:$P$1,0))&""

then copy down as required.

Hope this helps.

Pete

[m1982j]

Thanks for the reply, it gives an N/A (value not available) error.
I don't really understand what the formula is doing so i can't figure it out.

Edit: it works on sample doc but not on my full version.

I'll have a look at adapting it.

[m1982j]

Works perfect, thank you so much!

[Pete_UK]

Glad you got there in the end.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

[dosydos]

another way would be to use the FILTER function.
In cell B20:

Please Login or Register  to view this content.