INDEX MATCH with multiple columns

[jewsbur0]

Hi,

I'm stuck with a Match INdex formula.

In the example above, how can I get the fruit that matches with the date to appear in column G? Is Match Index the right formula or is there something I could be using? Cheers!

 

[jewsbur0]

Just realised the image hasn't posted. The formula I'm trying to get will go in B7 next to 01-Jan.

What I'm basically trying to do is get the fruit that was sold on every date. Each date is unique, there are no date duplicates. (The data I'm actually using isn't fruits and dates, but easier this way!)

Product	Sold on	Sold on2	Sold on3	Sold on4	Sold on5
Apples	01-Jan	01-May	07-Jun
Pears	04-Jan	02-Feb
Bananas	05-Apr	10-Dec	11-Nov	09-Sep	07-Jul
Date	What
01-Jan	#N/A
04-Jan	#N/A
05-Apr	#N/A
01-May	#N/A
02-Feb	#N/A
10-Dec	#N/A
07-Jun	#N/A
11-Nov	#N/A
09-Sep	#N/A
07-Jul	#N/A

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[shreif]

Suppose your data starting from a1 to f4

Product	Sold on	Sold on2	Sold on3	Sold on4	Sold on5
Apples	01-Jan	01-May	07-Jun
Pears	04-Jan	02-Feb
Bananas	05-Apr	10-Dec	11-Nov	09-Sep	07-Jul
Date	What
07-Jun	Apples
04-Jan	Pears
05-Apr	Bananas
01-May	Apples
02-Feb	Pears
10-Dec	Bananas
07-Jun	Apples
11-Nov	Bananas
09-Sep	Bananas
07-Jul	Bananas

<tbody>
</tbody>

IN B7

=index($a$2:$a$4,sumproduct(--(a13=$b$2:$f$4)*row($b$2:$f$4))-1)

 

[billsmith90]

https://1drv.ms/x/s!AntW1ZrWMeX2gQNq01G4gmqqiJfO

ok i am very new to excel - and it does bamboozle me a lot!!!
what i am trying to do is to get the savings total to show up on the dash board just like income, expenses show up, after several hours of research i managed to get the "chart data page" to show up.
i then added the savings line (right at the bottom of "chart data" page) but i can not get it to show the right amounts on the dashboard page. I believe it is to do with the formula i have used for savings on the "chart data" page (=INDEX(Budget!C13:O13,,period)
could someone help me get the right formula so my dashboard up dates properly (Dashboard page has a scroll button at the bottom for each month - amounts should update as you scroll through the months)
let me know if this make sense or you need more info
thank you very much

 

[AliGW]

@ Billsmith90 - you are not allowed to hijack another person's thread. You need to start your own.

 

[billsmith90]

sorry, i thought i could post questions about the index formula here. (newbie)
i will start a new one