# Get instant live expert help on if isna vlookup

“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

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
=IF(ISNA(VLOOKUP(\$A4,'OP2 IR AMZ-Listings Tracker SKU'!\$A\$3:\$B\$500,2, 2,3,FALSE)),"SKU Missing",VLOOKUP(\$A4,'OP2 IR AMZ-Listings Tracker SKU'!\$A\$3:\$B\$500,2, 6,FALSE)) need help for correct the error
Solved by X. L. in 23 mins
Hi trying to get a formula using if, vlookup and isna to get the sum of values from differents rows in two different spreadsheets
Solved by I. C. in 30 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
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