Hi,
I am looking for a formula to return the quantity of the "orders" sheet based on column D (Job No) and column F (Article Number) of a sheet names "report" in cell F10
The sheet with the list is "orders"
Column B has the job no
Column G the Quantity
Column H is the Article Number
Column I is the Description
Many thanks
I am looking for a formula to return the quantity of the "orders" sheet based on column D (Job No) and column F (Article Number) of a sheet names "report" in cell F10
The sheet with the list is "orders"
Column B has the job no
Column G the Quantity
Column H is the Article Number
Column I is the Description
Many thanks
