Use ISBLANK Function with Named Range Instead of Cell Address

[Toner]

I have a spreadsheet that I would like to use the created cell name (in Name Manager) (not cell address) in the "ISBLANK" function in an "IF" statement to return a null instead of "0" if the cell is blank.

The problem is I cannot figure out how to represent the cell name in the formula instead of the cell address, pulling from a list of cell names.

The cell referred to by the name "CDS_A0.A" is located in sheet1, cell address B1 and contains the data "2012"
The cell referred to by the name "CDS_A0.B" is located in sheet 2, cell address C3 and contains no data.

In sheet 3, I have a list of all the cells with created names in Name Manager (600+) and would like to return the contents (if any) to ColumnB, and if the is nothing in the named cell, return a null, not a zero ("0").

Cell_Name Cell_Content
CDS_A0.A 2012
CDS_A0.B
CDS_A0.C
CDS_A0.D
............

I have tried the following but it just returns the name:

=IF(ISBLANK(A2),"",A2)

Thank you all in advance for your time!

[Paul]

Hi Toner, welcome to the forum.

Perhaps try using INDIRECT, e.g.

=IF(ISBLANK(INDIRECT(A2)),"",INDIRECT(A2))

?

[Toner]

Thank you Paul, I appreciate the note of welcome and thank you for providing a solution!

I am very grateful...