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.[TABLE="width: 163"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store[/TD]
[TD]Event Date[/TD]
[TD]Plan[/TD]
[/TR]
[TR]
[TD]5183[/TD]
[TD]9/30/2018[/TD]
[TD]29,700.00[/TD]
[/TR]
[TR]
[TD]757[/TD]
[TD]10/1/2018[/TD]
[TD]9,000.00[/TD]
[/TR]
[TR]
[TD]1249[/TD]
[TD]10/1/2018[/TD]
[TD]5,000.00[/TD]
[/TR]
[TR]
[TD]1515[/TD]
[TD]10/1/2018[/TD]
[TD]5,000.00[/TD]
[/TR]
[TR]
[TD]1712[/TD]
[TD]10/1/2018[/TD]
[TD]13,800.00[/TD]
[/TR]
[TR]
[TD]1843[/TD]
[TD]10/1/2018[/TD]
[TD]5,000.00[/TD]
[/TR]
[TR]
[TD]1981[/TD]
[TD]10/1/2018[/TD]
[TD]11,400.00[/TD]
[/TR]
[TR]
[TD]2678[/TD]
[TD]10/1/2018[/TD]
[TD]8,700.00[/TD]
[/TR]
[TR]
[TD]2895[/TD]
[TD]10/1/2018[/TD]
[TD]6,900.00[/TD]
[/TR]
[TR]
[TD]5236[/TD]
[TD]10/1/2018[/TD]
[TD]5,000.00[/TD]
[/TR]
[TR]
[TD]5264[/TD]
[TD]10/1/2018[/TD]
[TD]9,100.00[/TD]
[/TR]
[TR]
[TD]92[/TD]
[TD]10/2/2018[/TD]
[TD]5,800.00[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 393"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Store[/TD]
[TD]9/30/2018[/TD]
[TD]10/1/2018[/TD]
[TD]10/2/2018[/TD]
[TD]10/3/2018[/TD]
[TD]10/4/2018[/TD]
[TD]10/5/2018[/TD]
[/TR]
[TR]
[TD]5183[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]757[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1249[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1515[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1712[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1843[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1981[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2678[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2895[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5236[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5264[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]879[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1998[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2716[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2780[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2783[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.