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?

Seán