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!!
 

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

Similar Threads

Lookup? 2
template creates invoice - how to create summary worksheet? 13
Using a lookup to return multiple values in one cell?? 4
Group Excel data in varying length financial periods 4/5 weeks 2
Creating a worksheet from others (IF statement) 2
Macro Question 1
Data Validation to exclude blank cells 6
multiple database lookup 1

Back
Top