Hi, everyone!
I need some help with a formula.

See, I have the table layout as shown above and I need the “CS Month” (FM) column to return the values from daily CS+IN (Row 2) column dinamically if the date value on the merged header (Row 1) is the same as today. So basically, I want to show “today’s CS+IN column in CS Month” dinamically. I’ve tried using indirect and match but I think I’m using it wrong since I couldn’t make it work. How can I achieve such feature?

Additional Info:

1. I’m using dd/mm format over the merged headers on Row 1.

2. The date over the merged headers are stored in the first column of each section (Right above the “In” header in Row 2)

I thank you all in advance!

​Hi, everyone!I need some help with a formula.See, I have the table layout as shown above and I need the “CS Month” (FM) column to return the values from daily CS+IN (Row 2) column dinamically if the date value on the merged header (Row 1) is the same as today. So basically, I want to show “today’s CS+IN column in CS Month” dinamically. I’ve tried using indirect and match but I think I’m using it wrong since I couldn’t make it work. How can I achieve such feature? Additional Info:1. I’m using dd/mm format over the merged headers on Row 1.2. The date over the merged headers are stored in the first column of each section (Right above the “In” header in Row 2)I thank you all in advance!  Read More

​