Lookup and match multiple columns
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 |
All times are GMT +1. The time now is 03:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com