As long as it's a unique combination, you could array-enter something
like to find out which row the data is in:

=SUM((Month="January")*(SalesRep="Smith")*(Amount=2000)*ROW(Amount))

On Tue, Jan 13, 2009 at 9:16 PM, smbyrne69 <smbyrne69@...> wrote:
> I can lookup up a number using the sumproduct function but I cannot
> seem to return anything if it is text.
>
> I have the following array formula:
> {=sum(Month="January")*(SalesRep="Smith")*(Amount=2000))}
>
> This only works with numbers. I need to modify this formula to return
> the row reference because I want to use it with an index function. The
> amount is necessary in order to lookup the text in column d. Is there
> any way to do this without using the CONCATENATE to return the match?