Linking a relative formula to another worksheet problem

L

lanek1

Let me know what I am missing...
1. I use this formula =IF(+'Order Journal'!B16="", (""),(+'Order
Journal'!B16)) to reference a cell on another worksheet.
2. On the 'Order Journal' sheet I delete out the row 16.
3. the formula does not continue to reference B16 -which is what I want it
to do- instead it gives me a #REF error - =IF(+'Order Journal'!#REF!="",
(""),(+'Order Journal'!#REF!))
4. I thought if the formula was relative it would always reference B16 no
matter what cell, row, column was deleted on that worksheet.
thanks in advance for help. Ricky
 
M

Max

Some thoughts:
1. Do not delete cells, just use the Delete key to clear. Deletion destroys.
2. Presuming that (1) will hold, continue to use this:
=IF('Order Journal'!B16="","",'Order Journal'!B16)
(it's your original, but cleaned up)
 
Top