Ladies & Gents,
Hopefully my example below is not confusing :)

In essence I have a table of 13 columns and 200 rows with a purpose of
recording course details people attend.
The column headings are descriptions and each row is an individual record of
a course undertaken and so certain data can be duplicated i.e. dept, persons
name etc.
Example:

   Dept      Team      Name     Course ......
Admin          1          xxx         yyyyy
IT                1          aaaa       wwww
Cook            4          ccc          yyyyy
Admin           1         tttt          yyyyy
Admin           1         xxx          www
Admin          2          sss          www

Depending on the question asked of me I need to be able to generate 1 of 3
individual reports. The main keyword for report 1 is the 1st column, report 2
- 2nd column or report 3 - 3rd column description i.e. depending on the
question.

I've tried index and match, vlookup and hlookup but my main problem seems to
be checking and displaying each true record i.e. shows first then stops...

Can you help please....

Cheers
Colin