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