Get instant live expert help on I need help with excel isna function

“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 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