If and or isblank is text

Hi all,

I'm a new user to excel and was wondering if someone could kindly help me with this problem.

All I want to do is tell excel that if something is displayed in that cell, then display the text.
If not, then look at another cell for text. If nothing displayed, then look in another cell until all options are exhausted (x5) in which case if nothing is displayed ,display null.

Is this the right way to go about the formula?

=IF(ISBLANK('Level 5'!D15),'Level 4'!D21,IF(ISBLANK('Level 4'!D21),'Level 3'!D26,IF(ISBLANK('Level 3'!D26),'Level 2'!D21, NULL)))

Apologies for being such a numpty!
Thanks in anticipation.

Please Login or Register  to view this content.

the pattern is if it is not blank, display it if not go look for the other cell..

Formula:

Please Login or Register  to view this content.

Oops, I just noticed I posted the same thing you did.