Ok, so I have the formula to check in a cell and if it's blank to return the other one instead. So if I have a date in Actual to take that one, if the cell is empty to take the planned.
I tried with "False" it works to show if there is a date in actual but does not provide planned dates, if I put "True" then it returns the planned date regardless if the actual is there.
to make it simple,
"False" returns only actuals
=IF(ISBLANK(Vlookup(A2, 'Sheet 1'A:Y, 12, FALSE)), Vlookup(A2, 'Sheet 1'A:Y, 11, FALSE), Vlookup(A2, 'Sheet 1'A:Y, 12, FALSE)
and "true" returns only planned
=IF(ISBLANK(Vlookup(A2, 'Sheet 1'A:Y, 12, TRUE)), Vlookup(A2, 'Sheet 1'A:Y, 11, FALSE), Vlookup(A2, 'Sheet 1'A:Y, 12, TRUE)
Thanks in advance
I tried with "False" it works to show if there is a date in actual but does not provide planned dates, if I put "True" then it returns the planned date regardless if the actual is there.
to make it simple,
"False" returns only actuals
=IF(ISBLANK(Vlookup(A2, 'Sheet 1'A:Y, 12, FALSE)), Vlookup(A2, 'Sheet 1'A:Y, 11, FALSE), Vlookup(A2, 'Sheet 1'A:Y, 12, FALSE)
and "true" returns only planned
=IF(ISBLANK(Vlookup(A2, 'Sheet 1'A:Y, 12, TRUE)), Vlookup(A2, 'Sheet 1'A:Y, 11, FALSE), Vlookup(A2, 'Sheet 1'A:Y, 12, TRUE)
Thanks in advance