Returning a lookup value from multiple sources

  • Thread starter Thread starter R Storrar
  • Start date Start date
R

R Storrar

I have 4 worksheets - WIP, Orders, Invoicing, Costs.

In the WIP sheet, I summarise data from Invoicing & Costs by Orde
number. Some of the Orders will be invoiced, some have costs, som
both. Some order numbers will appear more than once in each sheet, som
not in either.

Summarising the data is easy, once I have each order using SUMIF, bu
how do I get the unique order numbers from the other sheets into th
WIP sheet in the first place??

This is driving me mad!!
 
Back
Top