Good monrning,

Biff has been helping me with this, but I wasn't sure if I should add to
previous post since it's something slightly different. So, I apologize if I
did wrong.

I've looked at previous posts but still can't get it to work.

I have 2 worksheets in 1 spreadsheet. The first worksheet, Reports,
contains the following:

A B E
Case Name Report Date Worker
Jones, Thaddeus 9/1/2009 Dilbert
Smith, Thomas 8/23/2009 Giles
Jones, Thaddeus 9/15/2009 Dilbert
Smith, Mary 9/14/2009 Jenkins


The second worksheet, Treatment, contains the following:

A B C
Case Name Report Date Worker


I want to be able to type in the Case Name and Report date in the second
worksheet (because I can have duplicate case name, but not duplicate report
date)
and have the appropriate worker automatically appear like magic in column C.
(I have other data too that I want copied over, but that's really irrelevant
here!)

I've tried typing in the following formula in Treatment!C2, but am getting
#N/A:

=IF(ISERROR(LOOKUP(2,1/((Reports!A1:A1000=A3)*(Reports!B1:B1000=B3)),Repo rts!E1:E1000)),0,LOOKUP(2,1/((A1:A1000=A3)*(Reports!B1:B1000=B3)),E1:E1000))

Any help will be most appreciated.


--
Thanks,
Tina Hudson