Vlookup/Index match question

[barham]

HEllo Guys,

I need help. I have an excel spreadsheet with three columns. Column A has store numbers, B has dates and C has dollar values as displayed below.

I want to display column C values on another sheet that has Column A (store numbers) in a column and the dates in a row. I want to display the dollar values to match the date and store but I'm unable to come up with the formula. Both formats are displayed below.

Store	Event Date	Plan
5183	9/30/2018	29,700.00
757	10/1/2018	9,000.00
1249	10/1/2018	5,000.00
1515	10/1/2018	5,000.00
1712	10/1/2018	13,800.00
1843	10/1/2018	5,000.00
1981	10/1/2018	11,400.00
2678	10/1/2018	8,700.00
2895	10/1/2018	6,900.00
5236	10/1/2018	5,000.00
5264	10/1/2018	9,100.00
92	10/2/2018	5,800.00

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Store	9/30/2018	10/1/2018	10/2/2018	10/3/2018	10/4/2018	10/5/2018
5183
757
1249
1515
1712
1843
1981
2678
2895
5236
5264
92
879
1998
2716
2780
2783

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

Thank you for your help.

 

[Aladin Akyurek]

In B2 of Sheet2 (your 'another sheet') control+shift+enter, copy across, and down:

=IFERROR(INDEX(Sheet1!$C$2:$C$13,MATCH($A2,IF(Sheet1!$B$2:$B$13=B$1,Sheet1!$A$2:$A$13),0)),"")

 

[barham]

In B2 of Sheet2 (your 'another sheet') control+shift+enter, copy across, and down:

=IFERROR(INDEX(Sheet1!$C$2:$C$13,MATCH($A2,IF(Sheet1!$B$2:$B$13=B$1,Sheet1!$A$2:$A$13),0)),"")

Thank you very much for the help.

It worked.

 

[Aladin Akyurek]

Thank you very much for the help.

It worked.

You are welcome.