Lookup Funktion? Vlookup? How to make it general

[VickyExcelNewb]

Hey guys,
I hope someone here is kind enough to help me with my problem... I am kinda lost and I tried everything.
I have to solve to do some data adjustments and I already think about it for a long time but I am just not good enough in the excel world.
This is the exercise:
"To analyze the performance we need to include the spend in the reports. We pay the networks on a CPI (Cost per Install) but it is not included in the data we track. Please add a column with the spend in the raw data using the cost per installs in the tab "CPIs".

Sooo what my function needs to do is clear. It somehow need to go through the column and read out the name of the campaign (example: "us_Lovapp_CPI_2015_07") and copy the number of the installs. Then multiply with the CPI of the campaign name in the sheet "CPIs"
What I tried is the following: =VLOOKUP("us_Lovapp_CPI_2015_07",$D:$F, 3, FALSE)*VLOOKUP("us_Lovapp_CPI_2015_07",$L:$M, 2, FALSE)
And it works. But of course only for one cell. And note that I just copied the CPI data on the same sheet. I don't know how to read other sheets out.

I attach a screenshot... otherwise it is not possible to understand I guess. Hopefully someone has the patience to help me on this one. Thank you

 

[Trevor_S]

I don't think that you need a lookup for the first bit, because you will always be on the right row. Your formula (in K4) should be:

=F4*VLOOKUP(D4,CPIs!$L:$M,2,false)

Then copy this down column K.

The formula assumes that you're also using columns L and M in the CPIs sheet - if not, substitute the columns that you are using.

 

[thecoffeeman]

Hello Vicky,

Can you check your private messages regarding this post?