Hi

I have a workbook in which Sheet1 contains a list of unique enquiry
numbers in column E, and a name in column C.

Sheet 2 also contains the same data - Name in column A; enquiry number
in column B and a third column C with a numeric value in it (time spent
on enquiry).

I need to create a formula that will look at the value from E in Sheet
1, match it to a value in B in Sheet 2, then compare the name in column
A Sheet2 to column C in Sheet1. If I have a complete match then I want
to input value from C in Sheet 2 into a new column in sheet 1.

Can anyone help, or perhaps point out a more simpler way of getting
this data across?

Many thanks.