formula

Copper Contributor

How can I use a formula that allows me to write a number found in a table if today is an especific month?

3 Replies

@jmolinaeusa 

You may check if TODAY() is in specific month, but what is in your table? Are where dates, months, etc and how they are linked to numbers you'd like to find?

@Sergei Baklan 

Thank you Sergei.
I have a table divided in months in one column and the next column one number per month.
What I need is that in other cell excel gives me the number from the previous table if today is "march" corresponding to that month

@jmolinaeusa 

Perhaps you mean something like this, not sure

image.png