Vlookup or Match formula...not sure

[Jaimee001]

Greetings all,

I have an excel report with 2 tabs.
Tab1 is the main tab with the account number and such.
Tab2 is the volume tab that has 4 years of revenue per account number

I want to append the revenues for years 2014 and 2015 to tab A
I can make the match on the account number but i'm not sure how to 'filter' by the year in Tab2.

I've attached a mock up of the report in question

Thank you in advance
Jaimee

 

[tomas]

Greetings all,

I have an excel report with 2 tabs.
Tab1 is the main tab with the account number and such.
Tab2 is the volume tab that has 4 years of revenue per account number

I want to append the revenues for years 2014 and 2015 to tab A
I can make the match on the account number but i'm not sure how to 'filter' by the year in Tab2.

I've attached a mock up of the report in question

Thank you in advance
Jaimee

Hi I put formula in yellow cells.I used sumproduct because originally I though you can have more occurances of one account and year then one.


If it's just one formula might have been easier obviously but anyway this one is working, but if you need I can do lookup for you

 

[eibi]

Jaimee,

I handled your request similarly to Tomas (with sumproduct).

But, if you are compiling lots of this data, it will pay dividends for you to use pivot tables instead of formulas. Excel's pivot tables are pretty powerful.

See attached.

 

[Jaimee001]

Thank you both Tomas and Eibi, both are excellent responses....I need to look at this a bit more and determine which is the best for me.

Thank you again!