Two possible formulas (PasteSpecial formula results into your column as Values, after that you can delete the column with formulas. Or simply use formula.).
When you have different number of persons, you have to edit the persons list reference range in formula. To avoid formula editing, you have to use dynamic named range for names list range defined and used instead of cell reference, or you define both your tables as Tables, and convert provided formula into Table formula.
|