“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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