Indirect function with relative movement

[vba_tester]

Hello everyone,

I'm currently using the indirect function with the IF function to identify if O111 is equal to N112.
The problem that I have is if I delete or add any rows the indirect function won't move to follow the last value on the O column.

Do you guys have any ideas on how I should change my formula which is currently:
=IF(N112=INDIRECT("O111");"a";"r")

Thank guys!

 

[Fluff]

You could use
=INDEX(O:O,ROW()-1)