Vlookup with Drop Down Menu

[Zaid]

Hello Every One,

I am attaching file for your reference.I have my summary table A1:C7 and my database table F1:R7. I have a drop-down cell in C1 having months. Now i want output in summary table as per the month selected and value coming from database.

Regards
Mohammad

[Ace_XL]

In C2

=INDEX($G$2:$R$7,MATCH(A2,$F$2:$F$7,0),MATCH($C$1,$G$1:$R$1,0))

Copy down