Index match vlookup

[Pripri]

Please help, I’m trying to accomplish the same result in this table with a formula when looking for thousands of data.

Year Fruit Jan Feb March
2018 Banana. 1. 2. 3
2019 Banana 2. 3. 1
2018 Apple 4. 4. 4
2019 Apple. 2. 5. 3

Thanks

 

[Gerald Higgins]

Give us a clue, what do you want the results to be ?

 

[Pripri]

Please help, I’m trying to accomplish the same result in this table with a formula when looking for thousands of data.

Year Fruit Jan Feb March
2018 Banana. 1. 2. 3
2019 Banana 2. 3. 1
2018 Apple 4. 4. 4
2019 Apple. 2. 5. 3

Thanks

I need the monthly result for a fruit in a year.
Like
3 banana for March in 2018

 

[Special-K99]

And your input is...?
In one cell? More than one cell?
Which cells?

 

[Pripri]

Sorry, my input would be the Year to date total for a specific month. If I'm looking for banana 2018 and we are in March, my result would be 6

 

[Pripri]

Sorry, I meant the year to date result.
If we were in March 2018 banana, my result would be 6

 

[Pripri]

One cell that would reflect my year to date total for each year and each fruit.
I'm trying to compare totals

If we are looking for March 2018 bananas, my result would be 6
If we are looking for March 2019 apple, my result would be 10

 

[Gerald Higgins]

OK let's slow down a bit.

It looks like you have two types of INPUT.

First of all, you have a table of source data, which looks like the data you posted in your first post
Col A = year
Col B = fruit
Col C = data for January
Col D = data for February, and so on.

Second, you have an input of the SPECIFIC year, fruit, and month.
This is another 3 values, let's say they are held in cell A1 for year, B1 for fruit, and C1 for month.
Then you want to calculate an OUTPUT, which is the year's total for that fruit, up to the month specified in C1.

Is this right ?
Don't worry if the cell references are not quite right, you can adapt any solution we come up with to reflect your actual cell references.

I want to check this is right, because this looks like the type of situation that seems fairly straightforward, but once people start offering solutions, a raft of further complications get thrown in.
Are there more complications ?

Also, perhaps consider your posting style.
It usually doesn't add alot of value to quote your own (or anybody's) posts in full, unless there's a good reason to.
It just makes the thread longer and a bit harder to read.
Also, posting several times in a few minutes is un-necessary - if you make a post and then quickly realise you've got more to say, consider editing the post you've just made.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1107295-sum-ifs-index-match-post5327694.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).