Hi there,

I haven't managed how to do these SumProduct functions yet. The
following is a bit of a cheat but does work:

In cell A1 enter:

='Density Sheet'!A1&'Density Sheet'!B1

Then copy this formula down the length of the column equivalent to the
data in density sheet

Assuming that your two criteria are going into cells B+C1 then in D1
enter:

=B1&C1

Your final formula goes into D1:

=INDEX('Density Sheet'!D:D,MATCH(D1,A:A,0))

...and there you go.

Sorry its a dirty get around but if it works!...

Will depend on you never having a repeat value when you concatenate the
Density data. I'm assuming this will be pretty unlikely if column A has
got names, sample IDs since these will be unique (I'd avoid sticking
numbers at the very ends of the names if you can help it.)


--
Tristan
------------------------------------------------------------------------
Tristan's Profile: http://www.excelforum.com/member.php...o&userid=34061
View this thread: http://www.excelforum.com/showthread...hreadid=539006