You may be well-accustomed to using cell references in Excel ... you could have the individuals' names accessible through a drop-down menu, so that the lookup table takes up only a single row.