hat
3. Ou ka aplike fòmil menm jan an =IF(ISERROR(VLOOKUP(A2,'Fruit List 2'!$A$2:$A$22,1,FALSE)),A2,"") (A2 se fwi a nan fwi lis 1, ak 'lis fwi ksun'! $ A $ 2: $ A $ 2 se seri a ki gen valè ki manke ou ap chèche pou) jwenn valè ki disparèt nan lis fwi 22 (al gade anba a Ekran ), ak Lè sa a, mete aksan sou valè sa yo ki disparèt nan Fwi Lis 2 manyèlman.
eng
3. You can apply similar formula =IF(ISERROR(VLOOKUP(A2,'Fruit List 2'!$A$2:$A$22,1,FALSE)),A2,"") (A2 is the fruit in Fruit List 1, and 'Fruit List 2'!$A$2:$A$22 is the range whose missing values you are looking for) to find out missing values in Fruit List 2 (see below screenshots), and then highlight these missing values in Fruit List 1 manually.