Hello,
Please can you help me with a formula, where the lookup value = SO number (SO 28), and the outcome is the "Net Amount" of the LATEST Confirmation number (SO28-4 in this case).
Desired outcome would be SO28 value = SO28-4 (latest confirmation no.) = Net amount = 4.438,64
Can I somehow add a formula to cell so that it finds this value out of the 4 lines with the same PO number? Maybe by adding a column to add to the lookup?
Much appreciated!!
Please can you help me with a formula, where the lookup value = SO number (SO 28), and the outcome is the "Net Amount" of the LATEST Confirmation number (SO28-4 in this case).
Desired outcome would be SO28 value = SO28-4 (latest confirmation no.) = Net amount = 4.438,64
Can I somehow add a formula to cell so that it finds this value out of the 4 lines with the same PO number? Maybe by adding a column to add to the lookup?
Much appreciated!!