I have 7 spreadsheets that I am currently using the IF formula for. These spreadsheets all have the same format so currently the formulas sits at:
This is want I am trying to say, if Column C has one of the cells that is empty, then move to column C in the next sheet and so forth. The problem is sheet 2 does not start specificly with cell 'C5', instead, it references with the cell in the previous sheet.
=IF(Sheet1!C6="",Sheet2!C6,Sheet1!C6), all at C6's
=IF(Sheet1!C7="",Sheet2!C7,Sheet1!C7), all at C7's
=IF(Sheet1!C8="",Sheet2!C8,Sheet1!C8), all at C8's
I want each sheet to start at cell C5 no matter where the previous sheet cell ends off. When it finds a cell in column C that is empty, go to the next sheet starting at C5.
If sheet1 cell C5 is not empty then it will never go to Sheet2!C5 and will give the value of sheet1!C5 ..... make blank your sheet1!C5 then your formula will go onward ........ Just check and tell me if there is still problem .....