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.