vlookup from columns to row

[colans]

I have 2 files; one has volume data by invoice month setup in rows. The other file contains the net price setup in columns.
I want to bring the net price into the volume file based on product/contract/invoice month.
How?
I've attached an example file. Appreciate any help!

 

[Peter Bartholomew]

I think all you need is to MATCH the row and column and return the result using INDEX.

 

[bosco_yip]

Or………

In I3, copied down :

=VLOOKUP(B3,'Contract Pricing Table'!B$4:K$7,MATCH(G3,'Contract Pricing Table'!B$3:K$3,0),0)

Regards
Bosco

 

[colans]

Thanks to both of you; both solutions work well.