I have 2 seperate excel files where I need to compare data in one with data
in the other file.

A further twist is I need to match the Forename, Surname and date of
distribution which are fields in both files.

Firstly is it possible to compare or query data in one excel file with
another excel file and if so could anyone give me an example to work to

Secondly is it possible to query multiple fields for matching records across
these 2 files again an example would be greatly appreciated if this is
possible.

I would appreciate any help on this.