Hi

Wonder if you can help, I have attached the xls with sensitive data removed.

It has 3 tabs

Sheet 2 – which holds the data (and has links to the source based in Sharepoint)

PlannedMigrations

And

ActualMigrations

So the idea is if row on Sheet 2 has a date then it’s a plannedmigration and is should fall into the right cell on the plannedmigratiios tab in the right reporting period, if is migrated is TRUE then it should also show up on ActualMigrations within the right reporting period

I’m close but not close enough and can’t see what I’m doing wrong, help really appreciated.

Regards

John B

Attached Files

#Checklist - .xlsx (39.9 KB, 14 views)