dynamic offset if statement

[Godwin117]

I have this formula, if the first sheet is blank, then it will go to the second sheet first row with data and continue. It is similar to the vba pasting under that last row, however I don't want to use vba if I don't have to for this workbook. This hopefully is an easy fix to this problem. Any help would be greatly appreciated.

=IF('Sheet1'!A2<>"", 'Sheets1'!A2, OFFSET(Sheet3!A2, -'Sheet2'!G$1, 0))

Sheet2!G1 = countif(A:A, "<>")

 

[jasonb75]

then it will go to the second sheet first row with data and continue.

If you're saying that you want the formula in the first sheet to 'send' something to the second sheet, then that is not possible. A formula can only show a result in the cell that it is located in.

 

[Godwin117]

If you're saying that you want the formula in the first sheet to 'send' something to the second sheet, then that is not possible. A formula can only show a result in the cell that it is located in.

Correct, I'm just looking for the result of the cells. For example Sheet1 has data from A2:A5, and Sheet 3 has data from A2:A4, Sheet2 will display the data from Sheet1 on A2:A5, then from A6:A8 it will display Sheet 3 data. Hopefully this makes sense. I can put it in a table as well if that helps.

 

[jasonb75]

That will not be possible with formulas you will need to use vba.

There might be an office 365 only formula workaround if it is just sheet1 and sheet3 being pulled into sheet2, but any more sheets or pulling each one into the other 2 would not work.

 

[Godwin117]

That will not be possible with formulas you will need to use vba.

There might be an office 365 only formula workaround if it is just sheet1 and sheet3 being pulled into sheet2, but any more sheets or pulling each one into the other 2 would not work.

Ok thank you for your assistance.