Multiple variables to lookup in table of raw data

Hi guys,

I am trying to format some data into a simpler format and I am looking at creating a formula to look up the raw data and pull it.

My raw data is something like this:

A Jan 11
A Feb 30
A Mar 23
B Jan 8
B Feb 65
B Mar 46
etc.

The months are Jan - Dec and I need a formula that fits in this table:

Jan Feb Mar Apr
A
B
C
D

So basically assuming A is in cell A2 and Jan in B1

I need to enter a formula in B2 that pulls 11 from the raw data.


Any ideas?

Thanks!