Cell condition



How do I format a cell to return the value of a cell if i use the true/false
condition or any other suitable formula.

I have a column of monetary values, another column for a Purchase Order (PO)
Number; if I enter the PO Number I want the next cell to have the monetary
value so that I can obtain the sum of actual orders received.


Lets say your purchase orders data is in range A1:A100 and monetary
values data is in range B1:B100, and the cell you are going to key in
the purchase order number is C1, then use this formula in D1 to get the
monetary value




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