How do I create a formula that brings over a figure that has more than one
specific conditions. for example.

employee name in colum a, workplace in colum b, machine in colum c, and
total hrs work in colum d.

If an employee name, workplace and machine details in row 1 = to the
employee name in colum a ,workplace in colum b and machine in colum c then it
must bring over the total in colum d

--
laureen