Search code examples
google-sheetsvlookup

How do i get the header value of the cell matching today?

I have following table, that i want to get the header value(T1, T2, T3...) of the cell matching today's date. These dates are formatted as DD-MM-YYYY.

I tried using VLOOKUP to find the correct cell first, but that returns me a wrong date. Tried on 2023-04-7 but it returns me 21-03-2023.

=VLOOKUP(TODAY(), A3:U20, 2)

How do i do this?

enter image description here

Solution

  • Can you try:

    =tocol(index(if(A3:U20=today(),A2:U2,)),1)