difficult to work out

Hi all,

I'm currently using the following formula:

=IF(ISERR(FIND("CREDITEXPE",$B$2:$B$25,1)),(D2*-1),0)

But what I need is when excel finds "creditexpe" I want the "D2*-1" to be a figure from the same row as "creditexpe" but in a different column.

Can anyone help?