I am trying to derive a formula to return text or Row-Column addresses
with possibly more than one true instance and I am having trouble
getting it to work. I tried using the sumproduct function but it does
not return text. To fix this I added a column with nothing but numbers
to return them but when the function finds more than one instance where
it meets the requirements it sums the values (as it should) but I need a
formula to return both values seperately. Currently this is how my
formula reads.
A[Y]=SUMPRODUCT(--(D[Y]=Sheet1!D2:D2000),--(E[Y]=Sheet1!E2:E2000),Sheet1!A2:A2000)
where [Y] denotes the particular row in which the formula is entered. I
do not care if the formula that I need returns text or the Row-Column
address where each value is true. Any direction would be much
appreciated. Thanks.


--
jdurrmsu
------------------------------------------------------------------------
jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122
View this thread: http://www.excelforum.com/showthread...hreadid=507502