Does If + vlookup work in this case

[excelzunder]

Hello,

I need to complete the table but I'm not sure how to write the formula in this case.
Could you please advise.

Chart A: original data

[TABLE="width: 500"]
<tbody>[TR]
[TD]Project
[/TD]
[TD]Product
[/TD]
[TD]Store
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]A
[/TD]
[TD]Store1
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]B
[/TD]
[TD]Store2
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]A
[/TD]
[TD]Store1
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]C
[/TD]
[TD]Store3
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]A
[/TD]
[TD]Store1
[/TD]
[/TR]
[TR]
[TD]2233
[/TD]
[TD]A
[/TD]
[TD]Store1
[/TD]
[/TR]
[TR]
[TD]2233
[/TD]
[TD]B
[/TD]
[TD]Store2
[/TD]
[/TR]
[TR]
[TD]2233
[/TD]
[TD]A
[/TD]
[TD]Store1
[/TD]
[/TR]
</tbody>[/TABLE]

Chart B: I need to complete "Store" column by formula

[TABLE="width: 500"]
<tbody>[TR]
[TD]Project
[/TD]
[TD]Product
[/TD]
[TD]Store
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]A
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]B
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]A
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]1973
[/TD]
[TD]C
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]2233
[/TD]
[TD]A
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]2233
[/TD]
[TD]C
[/TD]
[TD]???
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you!

 

[Aladin Akyurek]

Let A:C house Chart A and E:G ChartB.

In G2 control+shift+enter, not just enter, and copy down:

=INDEX($C$2:$C$9,MATCH($F2,IF($A$2:$A$9=$E2,$B$2:$B$9),0))