Match (?) Help

[crudepuddle]

I am trying to create a dashboard where if a particular month is selected the relevant target for that month/period will appear. So far I have the below and am stuck on the final formula for the matching of targets to months:

[TABLE="width: 348"]
<colgroup><col width="12" style="width:9pt"> <col width="169" style="width:127pt"> <col width="167" style="width:125pt"> </colgroup><tbody>[TR]
[TD="class: xl48, width: 181, colspan: 2"]Date field to filter by[/TD]
[TD="class: xl50, width: 167"]Target Period[/TD]
[/TR]
[TR]
[TD="class: xl44, width: 181, colspan: 2"]Selector[/TD]
[TD="class: xl51, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl44, width: 181, colspan: 2"]Target Period[/TD]
[TD="class: xl51, align: right"]Jan-18[/TD]
[/TR]
[TR]
[TD="class: xl45, width: 181, colspan: 2"]Target[/TD]
[TD="class: xl54, align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Jan-18[/TD]
[TD="class: xl28"]£19,760 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Feb-18[/TD]
[TD="class: xl28"]£24,890 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Mar-18[/TD]
[TD="class: xl28"]£26,600 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Apr-18[/TD]
[TD="class: xl28"]£22,610 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]May-18[/TD]
[TD="class: xl28"]£24,320 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Jun-18[/TD]
[TD="class: xl28"]£24,320 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Jul-18[/TD]
[TD="class: xl28"]£22,420 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Aug-18[/TD]
[TD="class: xl28"]£22,420 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Sep-18[/TD]
[TD="class: xl28"]£24,035 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Oct-18[/TD]
[TD="class: xl28"]£24,035 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Nov-18[/TD]
[TD="class: xl28"]£23,845 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Dec-18[/TD]
[TD="class: xl28"]£20,330 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Q1 18[/TD]
[TD="class: xl28"]£71,250 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Q2 18[/TD]
[TD="class: xl28"]£71,250 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Q3 18[/TD]
[TD="class: xl28"]£68,875 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Q4 18[/TD]
[TD="class: xl28"]£68,210 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl28"]Year - 2018[/TD]
[TD="class: xl28"]£279,585 [/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, looks like you just need a simple VLOOKUP() - i.e.

Excel 2013/2016
	A	B
1	Date field to filter by	Target Period
2	Selector	1
3	Target Period	Jan-2018
4	Target	19760
5
6	Jan-2018	19760
7	Feb-2018	24890
8	Mar-2018	26600
9	Apr-2018	22610
10	May-2018	24320
11	Jun-2018	24320
12	Jul-2018	22420
13	Aug-2018	22420
14	Sep-2018	24035
15	Oct-2018	24035
16	Nov-2018	23845
17	Dec-2018	20330
18	Q1 18	71250
19	Q2 18	71250
20	Q3 18	68875
21	Q4 18	68210
22	Year - 2018	279585
Sheet1

Cell Formulas
Range	Formula
B4	=VLOOKUP(B3,A6:B22,2,0)