Cell condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

=VLOOKUP(C1,A1:B100,2,FALSE)

Regards

Govind.
 
Back
Top