AboutPricing

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.
< Go Back

    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