Combining two reports into one

T

TammyS

Report 1
Prod a 7 am - 10 am
Prod b 10 am - 11 am
Prod a 11 am - 3 pm

Report 2
Prod a, type 1
Prod a, type 2
Prod a, type 3
Prod b, type 1
Prod a, type 1

Report 3 (combines hours, delay, and wet waste from report 1 and the
specifics of report 2)
Prod a, type 1, 7 am - 10 am
Prod a, type 2
Prod a, type 3
Prod b, type 1, 10 am - 11 am
Prod a, type 1, 11 am - 3 pm

Is there a way to look up the information about Prod a from Report 1 and
transfer it to Report 3. Right now I'm combining the same products and using
a vlookup formula because the information changes daily but many of the
applications that my employer uses keeps this information separate.
 

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

vlookup or index/match formula?? 2
Lookup by multiple criteria. 5
Help with multiple values for a lookup 4
How to create Report showing All Product Sales by period ? 3
Creating A Report using Pivoted Query 10
Report from Crosstab with Select Dates Possible? 2
Multiple Vlookups in a range 3
Running Count By Week 6

Top