I've used the following formula to return the information I want to cell
N1434:

=SUMPRODUCT(--($Y$2:$Y$1404=$Y1434),--($E$2:$E$1404=$E1434),--($F$2:$F$1404=$F1434),N$2:N$1404)

In this instance it returns the value from cell N773, which is
correct.

Now in Cell N1433 I would like to return the value in cell N772. I
can't use the sumproduct function because the references can't be used
again without throwing off other calculations. I tried to get the row
function to go out and return N773 as an answer to something but failed
miserably. Any help is appreciated.

Jean


--
Jean
------------------------------------------------------------------------
Jean's Profile: http://www.excelforum.com/member.php...o&userid=17585
View this thread: http://www.excelforum.com/showthread...hreadid=547093