I have 12 cells in a row with number format and the value is from 1 to 12 representing 12 months in a year. I have another cell where I enter a date. From the date, I extract the month number, for eg; January is 1, February is 2 and so on. The date I enter is in fact employee date of joining. In another cell i have his salary amount. Now when i enter the date, i want excel to fill in the salary amount from the month he has joined and all the following months until end of year.
I am using the TEXT function to extract the number of month. I am trying to match the extracted number with the month number in the heading row and if true to enter the salary and continue to enter the same until month 12. But even though the extracted number is 01, it does not enter the salary in column 1.
I have shared the screenshot of my file herewith for your better understanding.
I am using the TEXT function to extract the number of month. I am trying to match the extracted number with the month number in the heading row and if true to enter the salary and continue to enter the same until month 12. But even though the extracted number is 01, it does not enter the salary in column 1.
I have shared the screenshot of my file herewith for your better understanding.
