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:

Date field to filter by	Target Period
Selector	1
Target Period	Jan-18
Target	#VALUE!
	Jan-18	£19,760
	Feb-18	£24,890
	Mar-18	£26,600
	Apr-18	£22,610
	May-18	£24,320
	Jun-18	£24,320
	Jul-18	£22,420
	Aug-18	£22,420
	Sep-18	£24,035
	Oct-18	£24,035
	Nov-18	£23,845
	Dec-18	£20,330
	Q1 18	£71,250
	Q2 18	£71,250
	Q3 18	£68,875
	Q4 18	£68,210
	Year - 2018	£279,585

<colgroup><col width="12" style="width:9pt"> <col width="169" style="width:127pt"> <col width="167" style="width:125pt"> </colgroup><tbody>
</tbody>

 

[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)