I experiment with a smaller data base, and came up with
=LOOKUP(2,1/(Sheet1!$A$2:$A$4&Sheet1!$B$2:$B$4=A1&B1),Sheet1!$ D$2:$D$4)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Adam Thwaites" wrote in message
...
Worksheet is called 'Raw Data'
Column A = Name
Column B = Date
Column D = Time

I need a lookup to pull out the first time (for one cell) and last time
(for
another
cell) based on criteria in a seperate worksheet ('Report') where A1
contains
the Name to filter on, and B1 contains the Date to filter on.

I used the fomula
=LOOKUP(2,1/('Raw Data'!$A$2:$A$10000=$A$1),'Raw Data'!$D$2:$D$10000)
to find the last time based on Name, but I don't know how to add the extra
date criteria in.

Thanks in advance for your help!

--
Adam Thwaites
Access Database Designer

Manchester, UK