Formula Help

  • Thread starter Thread starter avit
  • Start date Start date
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.
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a formula to act as a value 1
matching a customer with a twist.. 1
Help with ISNUMBER formula 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel lookup across entire workbook 1
Excel VBA 1
Excel formula, sum the value cell and if empty cell left blank 0
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top