MATCH returns a row position.
SUMPRODUCT doesn't.

=INDEX(C2:C5,MATCH("Region 1",A2:A5,0)+1)

HTH
--
AP

"Jasmine" a écrit dans le message de
news: ...
Is it possible to use the Sumproduct formula to search for a particular
word
and grab the amount in the next column, but 1 row down? For example, I
would
search for region 1, but want to grab the figure in the total loans column
next to Consumer.

Region Loan Type Total Loans
--------- ------------ --------------
Region 1 Commercial 150000
Consumer 75000
Region 2 Commercial 90000
Consumer 145000

If this is possible, how would the formula be written? Thank you so much!