Hi All,

I have implemented a logic to fetch the last value in a set of data(from a set of columns) by a formula like =LOOKUP(900000000000,'Sheet 1'!N1:Z1).
So with this formula I am able to fetch the last value populated in Sheet 1 from the columns N until Z.

If columns X, Y and Z are not filled then this formula fetches the value from column W. And so on.

The issue is that I want to do the same thing in MS Project. So all you excel experts, please help me. Can custom fields help?

Regards.