hat
1. Chwazi premye selil vid la san konte Lis fwi 2kalite Ki manke nan Fwi Lis 1 kòm header kolòn, pwochen antre nan fòmil la =IF(ISERROR(VLOOKUP(A2,'Fruit List 1'!$A$2:$A$22,1,FALSE)),A2,"") nan dezyèm selil vid la, ak trennen Manch nan ranpli nan seri a jan ou bezwen. Gade anba a:
eng
1. Select the first blank cell besides Fruit List 2, type Missing in Fruit List 1 as column header, next enter the formula =IF(ISERROR(VLOOKUP(A2,'Fruit List 1'!$A$2:$A$22,1,FALSE)),A2,"") into the second blank cell, and drag the Fill Handle to the range as you need. See below screenshot: