Liberty Prime
New Member
- Joined
- Dec 18, 2017
- Messages
- 18
Hi all!
I start my first post in this board with a question involving a vlookup function with three different variables I'm not able to make it work, in a context involving the use of AdWords and its expenses reports.
Here is the setup:
TAB 1: Here is the input raw data to be processed
TAB 2: Here is the output of the processed data
In the TAB 2 there is a column which should show the expenses according to the different accounts, based on the day of the month and country whose, values can be found in the TAB 1 (A for day, B for account, C for country and D for expenses). Until here, everything is fine.
The tricky thing I'm not able to solve is that in the TAB 2 there is a cell in which I manually type the day I want to check in the data from the TAB 1 (let's use C3 for instance), and the expenses should be summed from the first day of the month till the day specified in TAB2!C3 (included)
I don't know how to include a SUMIF or SUMIFS function to match this requirement in this Vlookup formula:
=iferror(vlookup($C$3&A5&B5,TAB1!$A:D,3,false),"-")
How can I order excel to perform this sum only if these values match?
Could you help me out with this please? Would be very helpful for the job I'm doing. I hope I was clear enough with the explanation, otherwise gladly will give more details.
Best regards!
I start my first post in this board with a question involving a vlookup function with three different variables I'm not able to make it work, in a context involving the use of AdWords and its expenses reports.
Here is the setup:
TAB 1: Here is the input raw data to be processed
TAB 2: Here is the output of the processed data
In the TAB 2 there is a column which should show the expenses according to the different accounts, based on the day of the month and country whose, values can be found in the TAB 1 (A for day, B for account, C for country and D for expenses). Until here, everything is fine.
The tricky thing I'm not able to solve is that in the TAB 2 there is a cell in which I manually type the day I want to check in the data from the TAB 1 (let's use C3 for instance), and the expenses should be summed from the first day of the month till the day specified in TAB2!C3 (included)
I don't know how to include a SUMIF or SUMIFS function to match this requirement in this Vlookup formula:
=iferror(vlookup($C$3&A5&B5,TAB1!$A:D,3,false),"-")
How can I order excel to perform this sum only if these values match?
Could you help me out with this please? Would be very helpful for the job I'm doing. I hope I was clear enough with the explanation, otherwise gladly will give more details.
Best regards!
