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. =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.