shadedlight
Member
Hello Excel wizards,
On the 'Pay Dates' worksheet I have a list of dates. On my 'This Month' sheet in A2 I want the sheet to somehow show the last filled date from my 'Pay Dates' sheet. Ex. If my last entry on the 'Pay Dates' sheet is 9-Sep then I want 9-Sep to appear in 'This Month' A2
I want some text in the front of the formulas in A15, A16, A19, A20, A23, A24. I attempteded to use this formula to accomplish it but it did not keep the % after the text.
=CONCATENATE("Lifestyle: ",INDEX('Pay Dates'!$F:$F,MATCH('This Month'!$A2,'Pay Dates'!$A:$A,0)))
In A15 I want the text Lifestyle to go in front of the % so it reads Lifestyle: 20%
In A16 I want the text Essentials to go in front of the % so it reads Essentials 20%
and so on through A19, A20, A23, and A24
Thanks
On the 'Pay Dates' worksheet I have a list of dates. On my 'This Month' sheet in A2 I want the sheet to somehow show the last filled date from my 'Pay Dates' sheet. Ex. If my last entry on the 'Pay Dates' sheet is 9-Sep then I want 9-Sep to appear in 'This Month' A2
I want some text in the front of the formulas in A15, A16, A19, A20, A23, A24. I attempteded to use this formula to accomplish it but it did not keep the % after the text.
=CONCATENATE("Lifestyle: ",INDEX('Pay Dates'!$F:$F,MATCH('This Month'!$A2,'Pay Dates'!$A:$A,0)))
In A15 I want the text Lifestyle to go in front of the % so it reads Lifestyle: 20%
In A16 I want the text Essentials to go in front of the % so it reads Essentials 20%
and so on through A19, A20, A23, and A24
Thanks