Formula Help

A

avit

Hi, i have a problem with a Formula.

Basically i want to search for a value in a cell, such as "in dispute"
or Pending, if the value "pending is found i then want the formula to
take the value in another cell on the same line (i.e. invoice number)
and put that value in a cell on another work sheet. I hope you
understand that :p, anyway any help you be greatly appriciated.
 
D

Dave Peterson

formulas can only return results to the cell that holds the formula.

You could have a formula in that final cell:

=if(countif(sheet1!a1,"*pending*")>0,sheet1!b1,"Not found")
 
Top