Hi all.
I have a spreadsheet with a cell that holds an account name entered by the user in cell $Z$2. I then have this formula =OFFSET(INDEX(lastwk_account:lastwk_campaign,(MATCH($Z$2,lastwk_account,0)),2),0,) which returns the 1st campaign from a database list held in column lastwk_campaign...
Hi All
Can someone help me here?
I have in my sheet a data list with the following columns:
account|campaign|impressions|clicks|cost|avg_position
I then have all the accounts and their relevant campaigns. I am trying to construct a formula that looks at an account value in cell A1, then...
Hi All
I am loving this site with all of its amazing knowledge. I am hoping someone can help me with my project. Whilst I am trying to learn more and more, this project is time sensitive and I am throwing it open to more knowledgeable people. By the way, I am using Excel on mac, Version 2011...