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

Project	Product	Store
1973	A	Store1
1973	B	Store2
1973	A	Store1
1973	C	Store3
1973	A	Store1
2233	A	Store1
2233	B	Store2
2233	A	Store1

<tbody>
</tbody>

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

Project	Product	Store
1973	A	???
1973	B	???
1973	A	???
1973	C	???
2233	A	???
2233	C	???

<tbody>
</tbody>

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))