Automatically autopopulate a cell from a cell in the same column based off the date in its row?

Annie Lindenberg

I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row?

For example, can I have the Associate Healthcare number from last month automatically populate into the table below it in the appropriate spot? And have this always autopopulate with the previous month's number without me having to change the formula or manual enter the number in both spots?

Thanks!

Ramzi K

@Annie Lindenberg

One way to do it is to use INDEX(MATCH... on the table with the month values and specify MONTH(TODAY()) - 1 as your criteria for the Month column.

I hope that helps.

Ramzi

Ramzi K

@Annie Lindenberg

One way to do it is to use INDEX(MATCH... on the table with the month values and specify MONTH(TODAY()) - 1 as your criteria for the Month column.

I hope that helps.

Ramzi