Report Puzzler
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUV
1
How I want to see the datavlookup examplevlookup locked example
2
DecD1A1A1A1A1For April's report I just want to pick out any values in column B that relate to that month and ignore the rest. How can I start in F2 and do this (top of the sheet)? I don't want any gaps in the list as this needs to be ready to download as a report - I am trying to save time you see! VLOOKUP can't quite do this as I am looking for only one value which is 'April' - examples provided.

I need to start in the top cell each time as this is where my report will start from, so I need to ignore any values from 'Dec' and 'May' yet still return any 'April' values in my first cell.
3
DecD2A2A1A1M1
4
AprilA1A3A1A1A2
5
AprilA2A4A2A1A3
6
AprilA3A5A3A1A4
7
AprilA4A6A4A1A5
8
AprilA5A7A5A1A6
9
MayM1A8M1A1A7
10
AprilM1A9A7A1A8
11
AprilA8A10A8A1A9
12
AprilA9A11A9A1A10
13
AprilA10A12A10A1A11
14
AprilA11A13A11A1A12
15
AprilA12A14A12A1A13
16
AprilA13A15A13A1A14
17
AprilA14A16A14A1A15
18
AprilA15A17A15A1A16
19
AprilA16A16A1A17
20
AprilA17A17A1
21
MayM1M1A1
22
JuneJ1M1A1
23
JuneJ1A6A1
24
JuneJ1A6A1
25
AprilA6A6A1
26
AprilA7A6A1
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
April Report