1

In the below screenshot, I'm trying to get B42 to show the value of whichever cell on row 40 is under the current month's column:

Formula returns N/A

As the dates are automatically generated using a transpose(arryaformula) function, each month is actually written as DD/MM/YYYY. However, I've formatted it so only the M and Y show.

The formula in the bar was lifted from another answer on here but, understandably, it can't find today's date as each column name is actually the first of each month.

Could someone help me, please?

  • Welcome. The formula in the formula bar isn't easily viewable, please add it as text to the question. – Rubén Jun 3 at 18:41
  • Formula is: =index(C40:40,match(TODAY(),C$33:$33,0)) – Chris Jun 4 at 8:28
0

=INDIRECT(ADDRESS(40, MATCH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), C33:33, 0)+2))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.