If you're retrieving a numeric value from that second sheet and there's only one
row that matches both criteria, you may want to try that =sumproduct() formula
again.

If you're retrieving a text value
or
had multiple rows that matched the criteria, but only wanted the first row's
information brought back

Then =sumproduct() wouldn't work.

From your posts, it sounds like =sumproduct() would work ok--well, it sounds
like it would work ok to me.

robbed wrote:

It does not work - it's not even applicable to what i am trying to acheive.....

"Carim" wrote:

Hi,

First Try the sumproduct() formula ...
and then see if you get your result ...


--

Dave Peterson