 # Get instant live expert help on if isna match “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need this function: =IF(ISNA(MATCH(G10,D3:D18,0)),"N","Y") to return a corresponding value in a different column if it matches instead of "Y". This is what I have currently... =IF(ISNA(MATCH(Input!C5,'Building to Address Mapping'!A2:A46,0)),Input!C5
Solved by C. Y. in 29 mins
=IF(ISNA(MATCH(B\$20&"_"&\$A26,Table1[[#All],[Date Ref]],0)),"",INDEX(Table1[[#All],[Descrip]],MATCH(B\$20&"_"&\$A26,Table1[[#All],[Date Ref]],0))) I have a formula. How can I check what is it "Table1", what range was used, how to change range?
Solved by Z. D. in 23 mins
I need to return the first non-zero and non "#N/A" value in a row of values. I have tried using the if function combined with the or function and the isna function (=IF(OR(ISNA(B6),B6=0),IF(OR(ISNA(C6)),c6=0),...), but it returns "#N/A" because there are #N/A values in the row.
Solved by O. C. in 19 mins
Using appropriate Lookup, match and/or Index functions in Excel (without using VBA) create a worksheet that identifies: a) Which students in the English class are NOT studying science b) Which students in the science class are NOT studying English the formula i used was: =IF(ROWS(D\$8:D19)<=SUMPRODUCT((--ISNA(MATCH(\$A\$8:\$A\$307&\$B\$8:\$B\$307,\$H\$8:\$H\$307&\$I\$8:\$I\$307,0)))),INDEX(\$A\$8:\$A\$307&" "&\$B\$8:\$B\$307,SMALL(IF(ISNA(MATCH(\$A\$8:\$A\$307&\$B\$8:\$B\$307,\$H\$8:\$H\$307&\$I\$8:\$I\$307,0)),ROW(\$B\$8:\$B\$307)-ROW(\$B\$8)+1),ROWS(\$D\$8:D19))),"")
Solved by V. U. in 27 mins
Private Sub CommandButton1() Dim myFormula As String myFormula = "=IF(ISNA(INDIRECT(""K""&MATCH(M2;B:B;0)));0;INDIRECT(""K""&MATCH(M2;B:B;0)))" Range("L2").Select Range("L2").Formula = myFormula End Sub When I start this macro code I have error 1004. If I remove from string initialization = then in cell L I have regular string witch is not formula.
Solved by O. J. in 11 mins