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
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").
I have tried the following but it just returns the name:
Thank you all in advance for your time!