I am using an OFFSET function to match names in column B to comments in
column R. The problem is that when the formula finds the first match it
stops. I need it to continue. Below is a copy of the formula I am using:

=OFFSET('Data '!B1,MATCH('Master TL Sheet '!C6,'Data '!B2:B800,0),16)

This workbook contains two sheets "master" is the report and the second is
the data. This is survey data for 96 managers with multiple responses for
each. Is the a macro that might be easier?