If two conditions are met, then copy the value.

UrbanNomad2

Hi Smart Team,

I have two sheets A and B, both sheets have similar columns and metrics from two different systems, I want to create a third sheet and collate data as per condition such as if Date=Date and Queue=Queue then copy date for that day. I was able to gather data from System A, from System B, I'm not getting the results.

I have attached the image for reference

Paul Newcome

Can you show the actual formulas?