Hi

I am a Novice in excel and would like some help when I'm analysing my google data. A bit of background first.

I check google adwords search term data with overlapping date ranges so that I make sure I get ALL data in an ongoing weekly review.

I have columns of Campaign, Adgroup & Search term.

When trying to minimise duplicates I use the Vlookup function in my latest sheet to lookup the search term column in a master sheet that has accumelated over time.

My problem is that in just looking up the search term, and removing any duplicates, I am missing the same search term that could fall in different campaigns/adgroups, therefore missing data and loosing money!

So, Is there a way of having a formula that i can run as a fouth column
Campaign, Adgroup, Search term, formula.

That will look at the data accross Campaign, adgroup and Search term and match it to the same columns in a master sheet of campaign, adgroup and search term. Therefore having an exact duplicate that I can leave out.

Your help will be most appreciated.

Bobby