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

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