Monthly Differences in Price for Seasonal Analysis

[SBF12345]

I would like to find differences in price between the first and last days of calendar months. I am having trouble with this task. How is best to approach separating dates or defining dates for input into the calculation of their corresponding prices?

 

[NeonRedSharpie]

Table 1: A1:B4

1/1/2014	1
1/31/2014	1.2
2/1/2014	1.3
2/28/2014	1.8

<tbody>
</tbody>

Table 2: E1:G3

	1	2
First
Last

<tbody>
</tbody>

(Note: 1 and 2 denote month)

Formula:

First:

=VLOOKUP(DATE(2014,F$1,1),$A:$B,2,0)

Last:

=VLOOKUP(EOMONTH(DATE(2014,F$1,1),0),$A:$B,2,0)

 

[SBF12345]

Table 1: A1:B4

1/1/2014	1
1/31/2014	1.2
2/1/2014	1.3
2/28/2014	1.8

<tbody>
</tbody>

Table 2: E1:G3

	1	2
First
Last

<tbody>
</tbody>

(Note: 1 and 2 denote month)

Formula:

First:

=VLOOKUP(DATE(2014,F$1,1),$A:$B,2,0)

Last:

=VLOOKUP(EOMONTH(DATE(2014,F$1,1),0),$A:$B,2,0)

Thanks!