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