Hi
I've got an IF statement that
i) checks if the value of a cell in another sheet is blank - if it is, then it returns nothing
ii) returns the value of that cell if it is not blank.
=IF('Tab1'!$S5="","",'Tab1'!$S5)
However, the formula keeps changing every time a macro, which re-arranges columns in that sheet is run.
It keeps changing to
=IF('Tab1'!$R5="","",'Tab1'!$R5)
Is there a way of amending the IF statement, so it always looks at column S, irrespective of whether the columns have been moved around?
Can it be done using the indirect function?
Thanks in advance.
I've got an IF statement that
i) checks if the value of a cell in another sheet is blank - if it is, then it returns nothing
ii) returns the value of that cell if it is not blank.
=IF('Tab1'!$S5="","",'Tab1'!$S5)
However, the formula keeps changing every time a macro, which re-arranges columns in that sheet is run.
It keeps changing to
=IF('Tab1'!$R5="","",'Tab1'!$R5)
Is there a way of amending the IF statement, so it always looks at column S, irrespective of whether the columns have been moved around?
Can it be done using the indirect function?
Thanks in advance.