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?
Bookmarks