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

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

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

I have a formula setup and need to add a isna function to clear away the #n/a for when a lookup is not found. The formula is : =If(I2<>0;vlookup(D2;sheet:sheet;2;false);) Where would I put this ? I have tried many options.

Solved by K. Y. in 29 mins

hello, what is the problem with this formula please? =if('extract fcst'!$B$1:$B$100="SOUTHAFRICA"; ISNA(VLOOKUP('Ecom only'!$B10;'extract fcst'!E:F;2;0));"0")

Solved by A. Y. in 21 mins

I am trying to use a V lookup to search the assessment scores of applicants in a table. The table with the assessment scores does not contain all applicants, so i need to use ISNA (I THINK). This is my formula: =IF(ISNA(VLOOKUP(B3,Assessment!$A$1:$E$31,5,FALSE)),"-",VLOOKUP(B3,Assessment!$A$1:$E$31,5,FALSE)) It is giving me the "-" for every result.

Solved by G. B. in 24 mins