hat
(1) Nan fòmil ki pi wo a, A2 se valè a nan fwi Lis 2, 'Lis Lis Fwi'! $ A $ 1: $ A $ 2 se seri a ki gen valè ki manke ou ap chèche.
eng
(1) In above formula, A2 is the value in Fruit List 2, 'Fruit List 1'!$A$2:$A$22 is the range whose missing values you are looking for.