Referencing an array formula
 

I have an array formula that I have set up. If certain criteria are not
found, I am getting an #N/A error (which is ok). Now I want to set up
another formula that if there is something populated (which happens to be a
number) in that cell that contains the array, I want that to populate
otherwise I want it to reference a different cell. I tried using 1, but on
the cells that contain #N/A, it will not reference the other cell. Any
suggestions?

Referencing an array formula
 

Use ISNA function to test for error and take appropriate decision.

"Sh" wrote:

I have an array formula that I have set up. If certain criteria are not
found, I am getting an #N/A error (which is ok). Now I want to set up
another formula that if there is something populated (which happens to be a
number) in that cell that contains the array, I want that to populate
otherwise I want it to reference a different cell. I tried using 1, but on
the cells that contain #N/A, it will not reference the other cell. Any
suggestions?

Referencing an array formula
 

Sh wrote:
I have an array formula that I have set up. If certain criteria are not
found, I am getting an #N/A error (which is ok). Now I want to set up
another formula that if there is something populated (which happens to be a
number) in that cell that contains the array, I want that to populate
otherwise I want it to reference a different cell. I tried using 1, but on
the cells that contain #N/A, it will not reference the other cell. Any
suggestions?

=IF(ISNA(target),something else,target)