Having a problem with Named Formulas

[Jiggers]

Hi am new to this forum, I hope I am posting in the correct place.
I am trying to name a formula that uses IF and INDIRECT.
My worksheet name is NF1 and has numbers in column A
I have defined the following named formulas:
Test1 that has this formula =IF(NF1!A1,"Yes","No") and works (display Yes).
Test2 that has this formula =INDIRECT("A"&ROW()) and displays the value of the cell in column A
Test3 that has this formula =IF(INDIRECT("A"&ROW()),"Yes","No") and does not work, I just get #VALUE!
Is there a way to this named formula working?
Thank you.

[oeldere]

Try this one

Please Login or Register  to view this content.

[martindwilson]

=IF(ISNUMBER(GET.CELL(5, INDIRECT("a"&ROW()))),"yes","no") will give yes for any number including 0