ISBLANK() does not work with ADDRESS() function

Question

Hi, I am using Excel to create an automatically updating sheet for a game I play. There is a mechanic that allows you to be trained in a skill, thus giving a boost to that skill. I am trying to write a function that checks to see if that certain cell is blank and if it is, do nothing, if is not empty, add 5. I am not using a direct call like 

IF(ISBLANK(BU2),0,5)

Instead, I am using

IF(ISBLANK(ADDRESS(ROW(),MATCH("Acrobatics Trained",1:1,0))),0,5)

because I want to be able to move around that certain cell and not have it mess things up so instead I search for it using MATCH(). It should come up false, but always comes up true, does anyone know why? Does ADDRESS() just not work with ISBLANK()?

Thanks in advance

Answer 1

ADDRESS returns a string, which is never blank. You want to know if a cell is blank, not whether its address is blank (it never is).

Perhaps

=IF(ISBLANK(INDIRECT(ADDRESS(ROW(),MATCH("Acrobatics Trained",1:1,0)))),0,5)

Answer 2

Oh now I feel dumb, thanks so much! That was exactly what I needed.