ExcelBanter - Formula returns #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula returns #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/258487-formula-returns-n.html)

David

Formula returns #N/A

I have a formula in cell B8
=INDEX(Sheet1!$A$2:$A$1201,MATCH(,COUNTIF($B$1:$B7 ,Sheet1!$A$2:$A$1201),))
with ctrl+shift+enter but it returns #N/A

1st of all, can I return a blank or a 0 if it cannot calculate the formula?

2nd, if it is there, how can I have a formula reading from this which says
if B8 = #N/A = 0 or calculate a sum formula if the answer is not #N/A?

Thanks

Gary''s Student

Formula returns #N/A

Use something of the form:

=IF(ISERROR(your_formula),"",your_formula)

--
Gary''s Student - gsnu201001

"David" wrote:

I have a formula in cell B8
=INDEX(Sheet1!$A$2:$A$1201,MATCH(,COUNTIF($B$1:$B7 ,Sheet1!$A$2:$A$1201),))
with ctrl+shift+enter but it returns #N/A

1st of all, can I return a blank or a 0 if it cannot calculate the formula?

2nd, if it is there, how can I have a formula reading from this which says
if B8 = #N/A = 0 or calculate a sum formula if the answer is not #N/A?

Thanks

All times are GMT +1. The time now is 05:57 PM.