Hi,

I've a number of sheets. The 1st cell in the C column is blank on all
the sheets except one. The same is true for the next cell, except the
value may be on a different sheet.
For example with sheets 1 to 3
.....sheet 1.....sheet 2....... sheet 3
C1........................................4
C2.....................3..................
C3........................................2
C4....1...................................

etc....

I hope you get the idea.

I've also got a summary sheet which I want to return a (different)
value from the sheet which happens to have a number on it (from M1).

I've got the formula below which works for 3 sheets, but I'd like
something which I can extend to any number of sheets.


=IF(ISBLANK(Sheet1!C7),IF(ISBLANK(Sheet2!C7),IF(IS BLANK(Sheet3!C7),"error",Sheet3!M$1),Sheet2!M$1),S heet1!M$1)

Any suggestions welcome!

Cheers


--
sphenisc


------------------------------------------------------------------------
sphenisc's Profile: http://www.excelforum.com/member.php...fo&userid=3697
View this thread: http://www.excelforum.com/showthread...hreadid=485919