Vlookup with wildcards
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Last NameFirst NameAgeEmailMatch criteria - 1 wildcard
2
RiveraIsabella68i.rivera@company.comPartial nameMye
3
JamesDaniel86d.james@company.com
4
LewisSophia56s.lewis@company.comLookup Table
5
MartinezSophia76s.martinez@company.comFirst NameJames
6
PetersonLiam42l.peterson@company.comLast NameMyers
7
PerryOlivia43o.perry@company.comAge29
8
EvansAva23a.evans@company.comEmailj.myers@company.com
9
SanchezJames65j.sanchez@company.com
10
PhillipsMason87m.phillips@company.com
11
BakerDaniel24d.baker@company.com
12
WrightJames67j.wright@company.comMatch criteria - 2 wildcards
13
JonesWilliam26w.jones@company.comPartial namelliv
14
GrayEmma20e.gray@company.com
15
LongWilliam31w.long@company.comLookup Table
16
PerezNoah37n.perez@company.comFirst NameBen
17
RichardsonEmma44
e.richardson@company.com
Last NameSullivan
18
CarterMadison69m.carter@company.comAge82
19
MyersJames29j.myers@company.comEmailb.sullivan@company.com
20
SandersEmily32e.sanders@company.com
21
HughesOlivia51o.hughes@company.com
22
MillerEmily74e.miller@company.com
23
FisherMason75m.fisher@company.com
24
MartinWilliam70w.martin@company.com
25
TurnerWilliam69w.turner@company.com
26
SandersLiam87l.sanders@company.com
27
SullivanBen82b.sullivan@company.com
28
BennettNoah54n.bennett@company.com
29
StewartEthan76e.stewart@company.com
30
WrightCharlotte87c.wright@company.com
31
OrtizJacob33j.ortiz@company.com
32
RossWilliam63w.ross@company.com
33
MitchellAva81a.mitchell@company.com
34
BellEthan30e.bell@company.com
35
StewartDaniel63d.stewart@company.com
36
JamesAva30a.james@company.com
37
WilsonCharlotte42c.wilson@company.com
38
ButlerLiam82l.butler@company.com
39
WilliamsJacob88j.williams@company.com
40
PhillipsMichael35m.phillips@company.com
41
RobertsSophia76s.roberts@company.com
42
HowardJames55j.howard@company.com
43
RiveraMadison49m.rivera@company.com
44
DiazJames45j.diaz@company.com
45
CarterLiam30l.carter@company.com
46
PetersonJames71j.peterson@company.com
47
ScottMichael60m.scott@company.com
48
RussellCharlotte58c.russell@company.com
49
WhiteJacob45j.white@company.com
50
MorrisAbigail61a.morris@company.com
51
RichardsonMichael37
m.richardson@company.com
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...
Main menu